• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

SQL Server 2005 - Create Server and Register?

Hello,

  I just migrated to SQL Server 2005 and was pleased to see that my old SQL 2000 Server Instance was backward compatable. I can actually view/edit/etc from the Studio Manager. Cool! I like backwards compatability.

  However, I would like to start a new 2005 server instance and have it be registered. How can I accomplish this?

  In the Studio Manager, in the "Registered Servers" window, it seems like all I can do is add a previously registered server instance (such as my SQL Server 2000 instance I mention above). There isn't a choice that I can see anywhere for creating a new one. Since all the 2005 client tools are brand-spankin' new and are totally diffent than the old enterprise manager, I'm not sure what to do. Maybe I am looking in the wrong place? What sequence of mouse clicks brings up a new server creator?




 
0
sapbucket
Asked:
sapbucket
  • 5
  • 4
  • 4
  • +1
2 Solutions
 
SireesCommented:
Right click on database engine New ->Server Registration
0
 
ptjcbCommented:
Or Right-click on the Server name - the drop down menu has Register.
0
 
sapbucketAuthor Commented:
While I am able to do what you mention, it still does not connect. Perhaps a discussion of what I am clicking will illuminate what I am doing wrong:

1.) start MS SQL Management Studio.
2.) Right click "Database Engine" and select new->Server Registration
3.) The wizard that appears I do the following:
 a.) under server name I type PAVILION\SQLEXPRESS
 b.) under authentication I select "Windows Authentication" (I am logged in as admin)
 c.) select "Save"
4.) I now see the server in the Registered Services list, but it is not started (no green "play button" arrow - just a white ball)
5.) I right click on PAVILION\SQLEXPRESS in the Registered Services list, and see that all the start/stop/pause/restart choices are disabled (greyed out).

And that is as far as I can get. I cannot start the registered server instance. Is there something I am missing? Having the server service appear in the Registered Services list is a great start - but doesn't really get me anywhere if I can't start it.

Thanks for the help so far...
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
sapbucketAuthor Commented:
I noticed that when I right click on PAVILION\SQLEXPRESS in the Registered Servers List and select Connect->Object Browser I get the following error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


However, a remote connection is not what I am doing at all. I am connecting using Windows Auth and the server resides on my cpu. It probably can't connect because it isn't started.
0
 
ptjcbCommented:
Check the SQL Server surface configuration.
0
 
sapbucketAuthor Commented:
Where is that?
0
 
imran_fastCommented:
go to sql server configuration manager you can find it in

control panel ==> administrative tool ===> computer management ==> services and application
enable tcp ip for sql sever network  and sql server client configuration
0
 
ptjcbCommented:
It is under Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server configuration manager
0
 
sapbucketAuthor Commented:
ok maybe I am taking this question down the wrong path.

I'll keep this as simple as I can.

<add key="hibernate.connection.connection_string" value="Data Source=SONYLAPTOP\SQLEXPRESS;initial catalog=MyDatabase;User Id=MyUserId;Password=MyPassWord" />


see the "Data Source = SONYLAPTOP\SQLEXPRESS"?

well that's the data source i want to connect to. before i can do that, I have to setup the data source. That means creating it, registering it, and starting it.

How can this be accomplished using SQL SERVER 2005? (If this is difficult - I did appoint 500 points for a solution!)
0
 
imran_fastCommented:
for all connecting strings you can check at
www.connectionsting.com 

Use this connection string instead and try

<add key="hibernate.connection.connection_string" Provider=SQLOLEDB.1;value="Data Source=SONYLAPTOP\SQLEXPRESS;initial catalog=MyDatabase;User Id=MyUserId;Password=MyPassWord;Integrated Security=SSPI;Persist Security Info=False" />
0
 
imran_fastCommented:
hi,
did you get your solution?
0
 
imran_fastCommented:
>>well that's the data source i want to connect to. before i can do that, I have to setup the data source. That means >>creating it, registering it, and starting it.
>>How can this be accomplished using SQL SERVER 2005?

You have to install sql server 2005 on a machine and this data sourse is the sql server machine name

In the below
SONYLAPTOP\SQLEXPRESS

SONYLAPTOP  is the sql server name
SQLEXPRESS  is the instance name

if you are usinf default instance then the data source will be simply

"Data Source = SONYLAPTOP"



0
 
sapbucketAuthor Commented:
Aha! Now I think we are getting somewhere.

How do I create a new "instance"?

So,

 SONYLAPTOP\MYNEWINSTANCE would be the data source I want to create.

It should be really easy. For some reason I can't figure out some supposedly intuitive sequence of mouse and keyboard clicks to do this.

Many thanks for the help
0
 
ptjcbCommented:
How do I create a new "instance"?

Rerun the installation. That is the only way to create an instance.  Run setup again and specify a different instance name.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 5
  • 4
  • 4
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now