June 20, 2004 at 12:10 am
Hii
I am facing probelm using SQL Server 2000.
The problem which i am facing is as follows :
> I am able to access databases on SQLServer2000 (or i should say MSDE) using Window forms.
> But whenever i try accessing the database using ASP.NET i am denied.
It says SQL Server does not exists or access denied.
> I am also unable to connect to the databases through Network.
> It also says that SQL server does not exist or access denied.
I install MSDE after installing Visual Studio.NET seperately.
Now when i use SQL Server 7.0 and do not install MSDE i am able to run ASP.NET pages and access data through it.
Please tell me what the problem is.
Can you please help me.
June 20, 2004 at 12:15 pm
How are you trying to connect? What's your connection string look like? Are you installing MSDE as a named instance or the default instance?
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
June 21, 2004 at 8:06 am
Did you create a login on the server and give it access to the database(s)?
Is the instance using Windows Authentication or Mixed Authentication (SQL Server and Windows)?
-SQLBill
June 21, 2004 at 11:24 am
Thanks for replying
I am using connection string as "server=Tushar\NetSDK;Integrated Security=true;
database=pubs"
I even tried creating a user and accessing it. But it failed.
I installed MSDE from .NET framework samples.
June 21, 2004 at 12:30 pm
Okay, back to step one....
When you installed MSDE you were required to provide a password for SA. Did you do so? If not then it is blank. SA is the account you need to use the first time you log onto MSDE. Then using the SA account you can add other logins and passwords.
-SQLBill
June 21, 2004 at 1:00 pm
A couple of "slammer-safe" MSDE installations were recently installed in our environment. No network protochols were installed by default.
Install Enterprise Manager on the box and check the network protochols.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply