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.
| Author |
Topic |
|
Danny__T
Starting Member
27 Posts |
 Posted - 2007-12-12 : 12:29:01
|
| Sorry if this is a very simple couple of questions, i've tried searching the docs but I'm not even sure which docs I should be reading!We run a few dedicated web servers with our web host. A new one of which has sql server 2005 on it until now we've only ever used 2000. Anyway I wanted to restore a 2000 database into 2005 and so logged into the machine for the first time, there was no management server installed just Sql Server configuration manager, fine I thought i'd be able to use SQL Express built into visual studio (2008) on my own machine. However when trying to connect I realised I didn't know the admin login details so called the host, they said there are no login details because there is no management software installed on the server and they'll install the Express version. Is this correct? Can you install SQL Server without an administrative login and you then can't connect to it until you've installed the management console?Secondly, As I mentioned I've got SQL Express installed as part of a visual studio 2008 install, we also have a copy of SQL Server 2005 standard for internal use only, I tried to use this to install the necessary client tools and it tells me I can't because I have a higher version already installed? Begining to wish I'd taken a look at 2005 much earlier than now as it seems like quite a big jump from 2000 in terms of management and setup...Any pointers much appreciated.Dan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-12 : 22:38:18
|
| Sql2k5 express doesn't come with ssms, but can download ssmse from Microsoft. By default, local admin has sysadmin rights in the instance. |
 |
|
|
|
|
|
noob 2005 version headaches