Database Connection issue. Connection string

Version 4
1

Pasted image1366×768 13.9 KB

I have gone through all the tutorials I can find and I can’t get the database connected. Now the program won’t open I get an error message saying I have the wrong connection string, but I’ve tried every variation I can think of and still it won’t work.

Data Source=RAHUL/SQLEXPRESS; User Id=sa; Password=sambapos; Database=SAMBAPOS

Please help!

2

So you installed SQL Express and setup a database instance called SQLEXPRESS and you enabled mixed mode authentication and enabled sa user and gave it password sambapos?

Can you access your database using MSSMS (Microsoft SQL Server Management Studio)?

1 Like
3

This will probably make no difference, but just in case …

Data Source=RAHUL/SQLEXPRESS
                 ^ incorrect
Data Source=RAHUL\SQLEXPRESS
                 ^ correct
2 Likes
4

Pretty sure it does need to be backslash…

1 Like
5

Yes but I think he just made a typo when typing it here. Though I cant tell by that screenshot.

6

Yes to all the above.

7

If u could access with SQL MANAGMENT mean that u have typo :wink: