I get this error when trying to login to my .NET app.
Cannot open database "Referral" requested by the login. The login failed.
Login failed for user 'Referral'.
Here is my connection string:
<add name="ProviderConnectionString" connectionString="Data Source=MyMachine\SQLEXPRESS;Initial Catalog=Referral;User Id=Referral;Password=password;"/>
I have logged into the Server via Object exploere so i know the uid and password is correct.
I also have SQL 2000 on the local machine as well.
Any ideas on this? I can;t get past this and it should be simple like it is with 2000.