How do I connect to SQL Server 2005? -- sql server new users

CodeManiac
6/6/2005 12:31:04 PM

Wow...SQL 2005 has me completely lost.

With SQL 2000 (and 7.0), I could connect to a remote database by adding the
remote server IP address to the Client Network Utility, and registering the
server in Enterprise Manager.

I can't figure out how to do that with SQL 2005, and I can't find the
documentation I need to find the answer.

Ultimately, I'm trying to connect the database through an ASP page, and I
need a connection string to do that. My connection strings don't work with
SQL 2005, and I can't connect to a remote database through the "SQL Server
Management Studio."

My hunch is that "remote" acess to SQL 2005 is turned off by default and I
need to turn it on.

Any ideas?

KevinHealey
6/8/2005 6:02:02 AM

Hi,

By default the SQL Server tools were not installed properly with the April
CTP. Uninstall it and download sql server express and manager for the June
CTP that came out today..(actually yesterday, but the links to it were dead).
Then use the Server tools to change to SQL authentication. By default it is
using the -E parameter which is windows authentication. You should see the
tools from the start menu after u install the june version I read somewhere.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : How do I connect to SQL Server 2005?