When I try to add a SQL database using Using Add New Data Source Wizard I get a Error.You can see dat in this screenshot
Anyone can Tell me whats the prob..
swappy
0
Light Poster
Recommended Answers
Jump to PostIs SQL Server on the same machine as VS2005 or on another machine-on the Network.
Jump to PostHi,
You need to First Create a Public User, in "SQL Server Authentication Mode" .
and give permission to the database.
Also Select Default Database for this User.
And You need to login thru this User, then you can access SQL Server Database Tables..REgards
Veena
All 5 Replies
sierrainfo
0
Junior Poster
Is SQL Server on the same machine as VS2005 or on another machine-on the Network.
regcure
0
Newbie Poster
It seems that either the SQL Server is not installed, disconnected, or corrupt.
swappy
0
Light Poster
No..It is installed properly and also running...I can see a icon in the taskbar...
QVeen72
104
Posting Shark
Hi,
You need to First Create a Public User, in "SQL Server Authentication Mode" .
and give permission to the database.
Also Select Default Database for this User.
And You need to login thru this User, then you can access SQL Server Database Tables..
REgards
Veena
sierrainfo
0
Junior Poster
Please see these Articles. The Answer lies in these Articles:
http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.