discovering sql server characteristics

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

discovering sql server characteristics

Author

Topic

porkpiehat
Starting Member

1 Post

Posted - 2006-11-05 : 05:23:57

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.

never no lament

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-05 : 06:47:46

http://www.carlprothman.net/Default.aspx?tabid=81
www.connectionstrings.com

Peter Larsson
Helsingborg, Sweden

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-11-06 : 14:07:47

In addition to Peter's links, I'd also suggest that you download the SQL Server Management Studio for SQL Server 2005 Express from the Microsoft website. I don't have an URL handy, but a search at http://www.microsoft.com should find it.

Ken

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-11-16 : 22:05:37

you can get both the engine and the tools here: http://msdn.microsoft.com/vstudio/express/sql/download/

SqlSpec - a fast, cheap, and comprehensive data dictionary generator for
SQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources