Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Connection from ASP.net to MSDE
Message
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Problem with Connection from ASP.net to MSDE
Miscellaneous
Thread ID:
01018238
Message ID:
01018238
Views:
69
Hi everyone.

I have a small C#/ASP.NET application which is using SQL Server. It has a grid and displays records from products table. It works fine on my development laptop. This is my string connection in the web.config:
<add 
key = "ConnectionString" 
value="server=(local)\netsdk;
database=northwind;
Trusted_Connection=true"
/>


I tried to deploy this application in my other laptop.
I installed MSDE with these parameters
INSTANCENAME = NETSDK
SAPWD = Guillermo
DISABLENETWORKPROTOCOLS = 0
SECURITYMODE = SQL
Then I installed the Sample DB northwind in instance NETSDK
I tried to run the page and I got this message:

invalid login for SERVER/ASPNET account

So I did this:
osql -E -S server\netsdk -Q "sp_grantlogin 'SERVER\ASPNET'"
osql -E -S server\netsdk -d northwind  -Q "sp_grantdbaccess 'SERVER\ASPNET'"
osql -E -S server\netsdk -d northwind  -Q "sp_addrolemember 'db_owner', 'SERVER\ASPNET'"
And then I tried again and I'm having this message:

SQL SERVER does not exist or access denied

I also tried to connect using DSN and it worked from DSN but not from the page (I changed my connection string of course)

I am able to connect from oSQL to my instance DB (local)\netsdk

I'm running out of ideas, can someone please guide me?

Thanks a lot in advance.
William
Next
Reply
Map
View

Click here to load this message in the networking platform