Friday, March 30, 2012

Microsoft SQL server 2005, connection string

<

connectionStrings>

<

addname="AppConnectionString1"connectionString="Data Source=".\SQLEXPRESS";AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL\Data\AdventureWorks2000_Data.mdf";Integrated Security=True"providerName="System.Data.SqlClient" />

</

connectionStrings>

I'm running Microsoft SQL server 2005. what is the error in the above code.

What is the error that you are getting?|||

a database not found error message.

here's some background:

I've followed the instructions here :http://msdn2.microsoft.com/library/ms310325.aspx as before, and everything went well till.

"To configure AdventureWorks to work with Web server controls"

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'"

My machine name is Leigh, i run win xp home edition, and MS SQL server 2005, so the above command in my case should be :

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N' Leigh\ASPNET'" ? (which doesn't work i assume because not happens )

No comments:

Post a Comment