Question about Microsoft SQL Server 2000 Standard Edition for PC
I have SQL Server 2000 installed on my "local" server, using the default settings, and want to use it with Visual Studio 2003. Query Analyzer doesn't pick up the databases I've created. Any suggestions? Thanks Michael
Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.
SQL Server runs on port 1433, so any firewall has to have it open.
Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.
Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.
Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.
Posted on Nov 24, 2007
Tips for a great answer:
Usually answered in minutes!
Step 2: Please assign your manual to a product: