Hi,

While trying to connect MSSql Server 2000 databse through ASP .Net application using c# I got below errror. Please help.

Sql Server does not exist or access denied.

Mubin

change your sql server authentication from mixed mode to windows authentication, then you dont have to mess with passwords. this might be the cause for the error.

change your sql server authentication from mixed mode to windows authentication, then you dont have to mess with passwords. this might be the cause for the error.

Thanx for your reply.

Actually, my SQL Server have Windows Aunthentication mode.

Please help me out.

Mubin

ok then right click my computer, click manage, select users and groups, add asp.net user to databaseadministrators group.

Thanx serkansendur,

I will try it, hope so it will work.

I will reply the same if it works.

Best regards,
Mubin

Thanx serkansendur,

I will try it, hope so it will work.

I will reply the same if it works.

Best regards,
Mubin

Hi,

Its working .......

Thanks a lot..

Mubin

Check yours connection string it must have password.

from web.config.

change the connection string without password.


Thanx for your reply.

Actually, my SQL Server have Windows Aunthentication mode.

Please help me out.

Mubin

This article has been dead for over six months. Start a new discussion instead.