discovering sql server characteristics

[porkpiehat]

Hi everyone, I'm a complete novice in databases :|
I have SQL Server 2005 Express Edition on my personal computer and need to connect to it through Java.
Therefore I need some information about it and don't know where to look. Some of them are:
=> the address of the server to connect to. This could be a DNS or IP address (I have installed the Server on my pc).
=> the instance to connect to (how can i find out where the instances are and which they are ?)
=> the port to connect to (i have no idea what this is at all)
=> the db is set to integrated security or do i have to give a username and password.
=> The name of the database to connect to (how can i find out which databases are available, if any)
note that there is no enterprise manager available. just a configuration manager, error and usage reporting, and surface area configuration.

many thanxs for reading my question.

 

[mrdenny]

Go and download the Microsoft Express Managment Studio (or something like that). It will give you some basic client tools.

The Address of the server will be the name or IP of the machine running SQL (your workstation).
The instance will be what ever you named the instance when you installed (SQLEXPRESS by default when SQL Express is installed).

The port number could be anything. It's dynamic by default. This can be set is the configuration manager.

The server security will also be what ever you set it to when you installed SQL Express.

The database name will be what ever the name of the database is that you create.

From the command prompt you can use SQLCMD to connect to the SQL Server and create databases, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com