Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Connection from ASP.net to MSDE
Message
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Titre:
Problem with Connection from ASP.net to MSDE
Divers
Thread ID:
01018238
Message ID:
01018238
Vues:
70
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform