SQL Database Connection question
Posted on 2014-02-18
I have inherited a website designed a long time ago which has a SQL database back end.
I have exported the database from the hosting site and I am now trying to connect to it using the existing code.
The connection to the live server is Data Source=mssql1.servername.com; Initial Catalog=Databasename; User Id=myuser; Password=mypassword;
I want to set the connection to my local server.
Data Source=localhost; Initial Catalog=Databasename; Integrated Security = true;
This connects to the database.
However when I run an sql query in the code
"SELECT * FROM tblA" I get an error "Invalid object name 'tblA'."
When I run the query in MSSMS it does not run either.
When I run the query "SELECT * FROM myuser.tblA" it works.
So it has something to do with the logins, but I cannot get it to work. I have tried creating a security login in MSSMS but I cannot attach it to the database.
Instead of the table name showing as dbo.tblA it shows as myuser.tblA.
Can anyone help please. It is relatively urgent as I have to do some work on this website.