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 |
|
kerrycorcoran
Starting Member
38 Posts |
 Posted - 2008-02-27 : 14:44:26
|
| I will need to use a unique instance name. Do i first need to install SQL 2005 using the Default Instance name, than install using my unique Instance name?Any help appreciated.Thanks,Kerry |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-02-27 : 15:17:24
|
| No You don't have ot install Default intance, By default, the first time you install SQL Server 2005 on a computer, Setup specifies the installation as the default instance; however, you can choose to install SQL Server as a named instance without installing the default instance firsthttp://technet.microsoft.com/en-us/library/ms143531.aspx---------------------http://dineshasanka.spaces.live.com/ |
 |
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-27 : 15:25:05
|
| What am I doing wrong then? It install fine, with a unique instance name, however when I attempt to install SP1 it fails?? |
|
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-02-27 : 15:29:19
|
| First place why sp1? why not sp2.Are you getting any errors---------------------http://dineshasanka.spaces.live.com/ |
|
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-27 : 15:31:48
|
| Funny you mention that. I was unsing Sp1 as that has been test/verified within my environment. The good news is I am building a new DB, thus I can begin testing with Sp2 :)I am loading Sp2 as we speak and had not had an issue so far.I may have been causing my own issue. I noticed I was using SQL Authentication, I am now trying with Windows Authentication.I'll keep you posted.Thanks,Kerry |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-27 : 23:30:22
|
| Seems you didn't enable sql authentication on the server. |
|
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-28 : 07:07:58
|
quote:
Originally posted by rmiao
Seems you didn't enable sql authentication on the server.
That's the odd thing, I did. Outside of trying to add Sp1, I could login to the SQL DB with SQL Authentication. |
|
|
|
|
|
|
|
|
Default Instance