Last post Feb 15, 2012 04:48 AM by necro_mancer
Feb 14, 2012 07:43 AM|enquiry|LINK
My problem in report is login erroe while executing the application
I'am using SQL Server 2008 in Windows XP
Visual Studio 2008
Machinename : MYMACHINE
I use windows authentication to login to SQL Server.
I have no user name or password set for sql server 2008.
What are the parameters i should be giving while asking for it? like username,password,servername etc.
when i give
select SERVERPROPERTY('MYMACHINE') i get NULL
Feb 15, 2012 04:48 AM|necro_mancer|LINK
In order for the login to work, you need to change the Windows Authentication to SQL Server Authentication. This means that you need to create a new SQL database user via the SQL Management Studio tool and then, you need to assign this user to your database
with dbo_owner permission.
Next, you need to alter your connection string on your web.config to reflect this db user details
Please mark this response as an "answer" if it helps you. Thanks heaps!