Hi RIZP,
I am Arun from India..
I read your problem.. I think you should follow the following instructions to solve your problem..
1) Use SQL Server and Windows Authentication from Ent. Manager.
2)Select This accout option from the bottom of the same screen that will enable Administrator and password test box.. do not change that.
3) Make a new login from Ent. Manager-Security(bottom of the list from where you select your database)-Logins option.
Right Click on the right pane and select new login option...
Give any name (ie- Arun) and select Sql Server Authentication option button and give password. select other permissions...click on OK button, it will ask password again for confirmation.
give it. and click on ok button.
Now you can see your login name on the right pane of Logins option.
and now use the following connection string..
"Provider=SQLOLEDB.1;Password=arun;Persist Security Info=True;User ID=Arun;Initial Catalog=master;Data Source=ARYABHATTSQL"
here ARYABHATTSQL is the name of your computer or sql server name.
test it ....
bye
Arun Kumar
B-259, Vaishali Nagar,
Jaipur-302021
Rajasthan
India
|