Hi i am working on a system for a client and they ahve recently asked me to change from SQL Server Authentication to Windows Authentication. I have set this up in the database (SQL Server 2008 using SSMS) and i can access the database by using my windows login.
The problem i am having is when i am rubbing the code (eithe locally or on the server). When i try to run the code it is breaking everytime i access a stored procedure saying "Could not find stored procedure". I think the reason for this is because within my atabase most of the stored procedures have a schema prefix. (e.g. MySchema.MyStoredProc). Within the code the schema prefix is not added to the start of the procedure name (and this would not be possible to change as there are thousands of calls to stored procs).
What i would like to know, is there any way of adding some code so that the .net code looks uo the Schema prefix?
I have looked online and it says this is possible within SSMS but i canot seem to get it to work and would be a much easier fix if i could chnage it from the .NET code.
Here is my connection string:
<add key="DatabaseConnectionString" value="Data Source=DATASOURCENAME;Initial Catalog=MYDATABASE;Integrated Security=true;"/>
Any help on this would be great.
Thanks