error in database connection

[mubin_attar]

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

[serkan sendur]

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.

[mubin_attar]

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

[serkan sendur]

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

[mubin_attar]

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

[mubin_attar]

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

[serkan sendur]

add to my reputation :)

[n4naeem]

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