Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 11th, 2004, 03:01 AM
Authorized User
 
Join Date: Apr 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to tact_259
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chat Server: Login failed. jtsroberts BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 March 19th, 2008 06:45 AM
Crystal Report "Login Failed" windows 2000 server HaniShtine Crystal Reports 0 December 7th, 2005 04:00 PM
Failed to copy objects from SQL server to SQL Serv monfu SQL Server 2000 4 December 4th, 2005 05:54 PM
Sql Server Login Failed error a42 ASP.NET 1.0 and 1.1 Basics 3 December 14th, 2004 05:19 PM
SQL Server / Login failed for user 'NT AUTHORITY ElPato ASP.NET 1.0 and 1.1 Basics 2 November 14th, 2004 10:03 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.