SQL Express Connection String????

[yyiiyyii]

i have a sql express connection string that works in 2003 and doesnt work in 2005


<add key="ConnectionString" value="server=COMPUTERS\SQLEXPRESS;password=;user id=;database=SomeData"/>

[Y.H Liu]

You might are stuck by SQL Server 2005 default security settings, i.e. SQL2005 does NOT allow network accessing by default. ComputerName\SQLExpress require network accessing, even ComputerName is just local computer. Try .\SQLExpress, or change SQL2005 setting to allow network accessing.

[yyiiyyii]

that did not work

[yyiiyyii]

i found it, this one works in 2005


server=COMPUTERS\SQLEXPRESS;Integrated Security=SSPI; Persist Security Info=False;database=CheckData

[mcmcom]

you should mark this thread as resolved.

mcm