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: 205

Filed under:

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'.

Related posts about sql-server-2008-express

NAT: Exposing SQL Server 2008 Express to the internet

as seen on Server Fault - Search for 'Server Fault'
Hi, I have a Windows Server 2003 SP2 machine with SQL Server 2008 Express installed. I have my network configured with a NAT. Internal clients can access the instance of SQL Server without a problem. I would like to enable SQL Server to be accessible from anywhere on the the internet. I am not… >>> More
SQL Server 2008 Express + Reporting Services on Windows 7

as seen on Server Fault - Search for 'Server Fault'
I'm trying to install SQL Server Express 2008 and Reporting Services on a x64 Windows 7 Machine for development purposes. I've installed SQL Server 2008 Express with the Microsoft Web Platform Installer I had to manually enable the SQL Server Browser in the Sql Server Configuration Manager and tried… >>> More
SQL Server 2008 Express - "Best" backup solution?

as seen on Server Fault - Search for 'Server Fault'
Hi! What backup solutions would you recommend when using SQL Server 2008 express? I'm pretty new to SQL Server, but as I'm coming from an MySql background i thought of setting up replication on another computer and just take x-copy backups of that server. But unfortanetly replication is not available… >>> More
SQL Server 2008 Restore from Backup fails with error 3241 'cannot process this media family'

as seen on Server Fault - Search for 'Server Fault'
I am attempting to backup a database from a SQL Server instance on one machine and restore it to another, and I am encountering the frequently discovered 'SQL Server cannot process this media family' error. Each of my instances are SQL Server 2008, but with different patch levels Restore: 10.0.2531… >>> More
Migrate database from SQL Server Standard to SQL Server Express for DotNetNuke

as seen on Server Fault - Search for 'Server Fault'
Hello, we have an old server that we want to dedicate fully as a public webserver (hosting a few DotNetNuke sites), and for this purpose we would like to install SQL Server Express (probably 2008) on the server and thus have both the Database server and the Web Server on the machine. But: The databases… >>> More

Developer IT

SQL Connection String to access localhost\SQLEXPRESS - Developer IT

SQL Connection String to access localhost\SQLEXPRESS

sql-server-2008-express

Related posts about sql-server-2008-express

NAT: Exposing SQL Server 2008 Express to the internet

SQL Server 2008 Express + Reporting Services on Windows 7

SQL Server 2008 Express - "Best" backup solution?

SQL Server 2008 Restore from Backup fails with error 3241 'cannot process this media family'

Migrate database from SQL Server Standard to SQL Server Express for DotNetNuke

Categories cloud