SQL Server 2005

[thecoldone06]

I have a client that I'm doing a server install for and one of their LOB applications use SQL server 2005. SQL 2005 came installed on server 2008 with no install media with it. In order to create a new connection for the database, I need the install media. Does anyone know how I can install the new connection without it? If not, do you know where I could download the install disk?

 

[ITMAN]

erm, is that what you want?

http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

 

[thecoldone06]

Thanks. I'll download it and see if it works. I'm not exactly sure which version comes with 2008 SBS but it's more than what they have. Thanks for the link.

 

[PatrickB]

In order to create a new connection for the databaseQUOTE]

Do you mean an ODBC connection? Does their software require it? Better performance can be had by using tcp/ip and native SQL access.

The client machines running their software can be set to use tcp/ip by running the SQL Client Configuration Tool (Start > Run > CLICONFG).

If their software cannot access SQL natively, then never mind.

-- Patrick B.

 

[thecoldone06]

no, not ODBC. When I start SQL server management studio, it asks which database you want to connect to. In order to create a new connection, it seems you need the install media. I downloaded what ITMAN (thank you) suggested and installed it on my machine. It did work and created an the instance I need. Next step is to try it on the server.

Where at in MO are you?

 

[PatrickB]

Hmmm, if you have the SQL Tools / SQL Mgmt Studio already installed, you should be able to connect to any database for which you have valid credentials. Oh well, I'm glad its working for you.

-- Patrick B.

 

[thecoldone06]

That's the problem, there is no database. I need to create a new connection then attach that connection to the database. Check out the attached pic. The instance I need to create is the server\junxure instance. I cannot create this instance and attach the database without the install media. But anyhow, I'm going to try with the install file and see what happens. Thanks!

 

[PatrickB]

Oh, I see. You are creating a new named instance of SQL. Now it makes sense that you would need the install media; you are creating a new sql server!

ITAIS1 is the computer name. The SQL "default instance" simply takes on the name of the computer. If you wish to create "named instances" to create separate environments, then yes, you have to install SQL again and give it a name. In your case, the named instance is "junxure" on the "ITAIS1" computer.

Thanks for letting me better understand the situation.

-- Patrick B.

 

[thecoldone06]

Yep, that's it! Sorry for the confusion. I got the new instance created and the database attached. The application found the database but was then having issues with 'not responding'. I was there on my lunch break (from day job) and had to go but she was calling tech support for the not responding issue which they seemed like they could fix. I told her if she needed I could do a conference call which she was happy about. So we'll see. Thanks guys for all your help!