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
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Installation mysteries

Author  Topic 

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-20 : 16:57:22
Hi all,

Installed the 64bit on Windows 7 today, set the security to Mixed (our Windows environment needs solidifying), set the SA password to something personal.

Then, I found I had to install Management Studio separately??!?! Did this, and can't connect to a bean. Authentication either fails or when I try to create a new database to which to login, I browse to the folders where the Sys DB's are - they're not home!!

Anyone knows what might be going on before I uninstall the whole thing and start fresh? Where the hell IS the uninstall program anyway??!?!

Thanks all,

JB

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-20 : 17:00:52
Please post the errors. We can't help without them.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-20 : 18:11:02
quote:
Originally posted by tkizer

Please post the errors. We can't help without them.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Will have to give you the exact wording tomorrow Tara but it was something like 'Instance of ID'.
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-21 : 09:54:13
Uninstalled, cleaned out the Registry, and started off the installation of the Advanced version of Express. Now it just comes to a dead stop after I accept the licencing. I don't mean freezing, the rest of the process simply fails to begin.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 11:08:46
Can't help you with that. Do you have a support contract with Microsoft?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-21 : 11:22:19
quote:
Originally posted by tkizer

Can't help you with that. Do you have a support contract with Microsoft?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Retried the installation and it was successful, however when I try to mixed login to (local) as SA, the message is:

"provdier: Named Pipes Provider, Error: 40 - could not open a connection....Error: 2"
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 11:25:38
Try this:

tcp:ServerName\InstanceName

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-21 : 11:28:16
quote:
Originally posted by tkizer

Try this:

tcp:ServerName\InstanceName

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



TCP? What do you mean?
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-21 : 11:29:45
Ahhh, CMD...'The System Cannot Find the Path specified"
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 11:34:51
You aren't using Management Studio?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 11:35:19
quote:
Originally posted by Jim Beam

Ahhh, CMD...'The System Cannot Find the Path specified"




You'll need to navigate to the exe or add the path to your path variable.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 11:35:49
quote:
Originally posted by Jim Beam

quote:
Originally posted by tkizer

Try this:

tcp:ServerName\InstanceName

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



TCP? What do you mean?




It's a shortcut way to override the default network library. If tcp works, we can then fix your system to force it to use tcp.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-21 : 13:08:11
quote:
Originally posted by tkizer

You aren't using Management Studio?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Wait wait, into what window/screen/box do I enter this "tcp:ServerName\InstanceName"? And what result do we hope for from it?

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 13:12:19
When it asks you what server to connect to. The hope is that it connects successfully.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-22 : 09:58:33
Popped in "tcp:ServerName\InstanceName" ...

I'm sure about the Server name, but where do I find the instance name if I can't even get into the system?


Error: 26 - Error locating Server/Instance Specified (Microsoft SQL Server)
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-22 : 10:29:39
I don't understand why it isn't OFFERING me a server name to connect to. I shouldn't have to offer server names or instances...that makes me suspect something is wrong with the installation.
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-22 : 10:58:59
I'm not Windows Admin on this machine, might that have any connection? (no pun intended)
Go to Top of Page

Jim Beam
Posting Yak Master

137 Posts

Posted - 2011-09-22 : 11:44:19
I've unblocked Management studio from the firewall, but nothing.
Go to Top of Page
   

- Advertisement -