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
mubin_attar 0 Newbie Poster
serkan sendur 821 Postaholic Banned Featured Poster
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 0 Newbie Poster
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 821 Postaholic Banned Featured Poster
ok then right click my computer, click manage, select users and groups, add asp.net user to databaseadministrators group.
mubin_attar 0 Newbie Poster
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 0 Newbie Poster
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 821 Postaholic Banned Featured Poster
add to my reputation :)
n4naeem 0 Newbie Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.