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 accountSo 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 deniedI 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