cannot open MSSQL database in c#

Asked May 13 '20 at 15:01

Active May 13 '20 at 15:08

Viewed 45 times

I've a local html page that I'm working on. It's mostly HTML and Javascript and some aspx c#. Whenever I am trying open the database, I get error: System.Data.SqlClient.SqlException: Cannot open database "Database.mdf" requested by the login. The login failed. Login failed for user 'ROYI\user'. I searched a bit on the internet, and I've learned that this uses the windows authentication but it doesn't seem to work. I don't have a password for this db, so why can't it connect?

My connection string is:

"Server= localhost; Database=Database.mdf; Integrated Security = SSPI; ";

When I do:

SqlConnection conn = new SqlConnection(connString);
conn.Open();

I get the error on conn.open();.

Where is the problem with my connection string?

edited May 13 '20 at 15:08

jarlh

40,041
8
39
58

asked May 13 '20 at 15:01

Royi Levy

Is the Database name is "Database.mdf" or you trying to open a connection to a MDF file? – Sathish Guru V May 13 '20 at 15:03
Might be helpful, Check this out https://stackoverflow.com/questions/173209/how-do-i-connect-to-an-mdf-microsoft-sql-server-database-file-in-a-simple-web – Vijay Rajendiran May 13 '20 at 15:08
The title says MSSQL database, but then the tag is used. Which dbms is actually used? – jarlh May 13 '20 at 15:09
@SathishGuru the name is `Database` and the file type is `mdf`. – Royi Levy May 15 '20 at 06:37
@jarlh the database file is of type `mdf` – Royi Levy May 15 '20 at 06:54
@VijayRajendiran I tried this: `Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;` but I don't really know what the difference between `mydbfile.mdf` is and `dbname`. – Royi Levy May 15 '20 at 06:56

cannot open MSSQL database in c#

0 Answers0