Member Avatar for swappy

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..

  • 4 Contributors
  • 5 Replies
  • 122 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by sierrainfo
Member Avatar for sierrainfo

Is SQL Server on the same machine as VS2005 or on another machine-on the Network.

Member Avatar for regcure

It seems that either the SQL Server is not installed, disconnected, or corrupt.

Member Avatar for swappy

No..It is installed properly and also running...I can see a icon in the taskbar...

Member Avatar for QVeen72

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

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.