SQL Connection String to access localhost\SQLEXPRESS
Posted
by
user34683
on Server Fault
See other posts from Server Fault
or by user34683
Published on 2011-03-11T07:17:46Z
Indexed on
2011/03/11
8:12 UTC
Read the original article
Hit count: 228
sql-server-2008-express
I've installed SQL Express on my PC hoping to do some practice creating tables and then modifying them. I coded a webpage in Visual Studio to, basically, SELECT * from a table in the SQLEXPRESS, but I can never get the connection string to work. Please help
My connection string
"Data Source=localhost\SQLEXPRESS;Initial Catalog=test;User Id=xaa9-PC\xaa9;Password=abcd;"
Error Message:
Query is select * from tblCustomers where username='johndoe' error is Login failed for user 'xaa9-PC\xaa9'.
© Server Fault or respective owner