how do I create a sql server within a sql server group?

[Goha]

How do I create a sql server WITHIN a sql server group that contains the tables, sp, views, users, rules, etc...

I need to create a new server within a server group .
example

+ CVS (server group)
- Development (server)
- Quality_Assurance (server)
- Production (server)
+ Duane Reade (server group)
- Development (server)
- Quality_Assurance (server)
- Production (server)
+ Rite Aid (server group)
- Development (server)
- Quality_Assurance (server)
- Production (server)

Thanks in advance....

 

[tlbroadbent]

I assume you refer to Groups and Servers in SQL Enterprise Manager. If this is not correct, please clarify.

SQL 2000: (Should work in SLQ 7 also.)

Add Group:
1) Open Enterprise Manager
2) Right-Click Microsoft SQL Servers
3) Click on New SQL Server Group
4) Enter the Group Name and click OK
5) Repeat for all groups to be added

Add Server:
1) Open Enterprise Manager
2) Right-Click the SQL Group where the server wil be added
3) Click on New SQL Server Registration
4) Enter the Server Name
5) Select authentication mode - Enter password if necessary
6) Select options desired and Click OK
7) Repeat for all servers to be added Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Goha]

Creating the group is no problem, it is creating the actual server. I did what was told up above and got the following...

Production - Specified sql server not found. ConnectionOpen(createfile())

-----

I am doing the initial creation of the server. I do not want to import the server.

Thanks again

 

[tlbroadbent]

What do you mean by creating a Server?

The instructions that I provided were for registering a server in Enterprise Manager. In order to register a server it must already exist. You create servers by installing an instance of SQL Server on a Server.

Help me understand what you really want to do. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Goha]

what I want to do is actually as you said register the server so that i can create tables and base an application of that server. for example the table, development.dbo.inventory . I am trying to create (register)development so that i can create the table inventory in development. registering development is my issue here.
(development = server name)

however i get the problem when i register it (the error above) the only server to register is the name of my hard drive 'MAXTOR - WIN2KPRO' this is the only one available if i choose that one i get that error, if i type some other name i get that one. it is getting annoying. I have followed all the help files they tell me to do the same as u are telling me and i am following that to the letter.

I am using Windows 2000 professional (NOT server). is this an issue?? Do I have set anything in the ODBC??

I hope this clarifies it better...

thanks again....

 

[tlbroadbent]

I think you may be confusing Server with Database. "development.dbo.inventory" is the format of a table name. "development" would be the name of the database. "dbo" would be the owner of the table. "inventory" would be the table name. Are the "server" names listed in your 1st post actually the names of servers or databases?

Is SQL Server running on the Windows 2000 Pro workstation/PC? Which version and edition of SQL Server is running? If you are trying to register a local server, that is running Developer Edition, Personal Edition or MSDE, you should be able to register it as (local) or the actual computer name - not the hard drive name, unless it is the same.

What network library are you using on the client? Is SQL Server using the same net library? I'm not familiar with Windows 2000 Pro so I'm not sure if all net libraries will work. If all else fails use TCP/IP.

Are you sure that SQL Server is actually running? You can't register a server if the SQL isn't running.

You can use the Client Network Utility to set up an alias for each SQL Server you want to register. You provide an address (IP address) and an alias name. You can also use it to choose the net library to use when connecting. If you can't find a shortcut, you should be able to find the program file, cliconfg.exe, in the WINDOWS\SYSTEM folder. See SQL BOL for more details on this utility. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Goha]

+Are the "server" names listed in your 1st post actually
the names of servers or databases?
-No I am actually talking about servers NOT databases.

+Is SQL Server running on the Windows 2000 Pro
workstation/PC?
-Yes. A Standalone PC (workstation)

+Which version and edition of SQL Server is running?
-SQL Server 7.0

+you should be able to register it as (local) or the
actual computer name - not the hard drive name, unless it
is the same.
-the pcname and the HD name are distinct.

+What network library are you using on the client?
-I don't understand the question

+Is SQL Server using the same net library?
-I don't understand the question

+Are you sure that SQL Server is actually running?
-I do not know how do I check

please be paitent with me this is the first time I
install it from scratch and i am doing it on my own.

 

[osjohnm]

+What network library are you using on the client?
+Is SQL Server using the same net library?

A:
SQL Server uses different communication protocols eg. IPX, TCP/IP etc. If instance might not be able to communicate with each other if their netowrk libraries were setup differently.

+Are you sure that SQL Server is actually running?

A:
Either on your client machine since u have Personal Edit
or on the server(you are connecting to) go start/programs/sql server/service manager.
That will tell you.

One last thing if the server that you are trying to connect to is using sql server 2000 and you are using sql server 7 the 7 instance won't be able to see the 2000 instance. 2000 can see 7 but not the otherway round

 

[tlbroadbent]

Which Edition of SQL 7 is running on the Work Station? It cannot be Enterprise or Standard Edition because they only run on Servers. It must be the Desktop or Developer Edition. It might be MSDE but that is less likely. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Goha]

tlbroadbent - I am using the developer edition

osjohnm -
+Are you sure that SQL Server is actually running?
-I do not have a service manager in my start menu., I have
an enterprise manager

+What network library are you using on the client?
-I do not know, but my pc uses tcp/ip for the home network
does that help?? how do I check??

 

[tlbroadbent]

You should have the Service Manager in the Same Program Group on the start menu as Enterprise Manager. If it is missing, you may have an incomplete installation.

Look in the SQL program folder (C:\mssql7\binn) for the following files. If you don't find the directory or the files perform a FIND to locate the files.

sqlserver.exe - This is the SQL Server executable
sqlmangr.exe - This is the Service Manager executable

If you find sqlmangr.exe, execute it. Check if SQL Server is already running. If not, try to start SQL Server. If the service manager cannot start SQL Server, run sqlserver.exe. It will start in a Command prompt Window which will be a Console for viewing, only. You'll not be able to enter SQL commands the but you will view events that are written in the error log.

Another helpful tool is the Network Client Utility. A shortcut for this program should also exist in the SQL Server programs folder. The executable is named cliconfg.exe and should be in the C:\WINDOWS\SYSTEM\ folder. Use this program to configure your client to access SQL Server.

Did you install SQL Books Online while installing SQL Server? As you know, there is no printed documentation. All Documentation is available in electronic books that can be installed from the SQL Setup CD. If you did not install them, I recommend doing so and then reading carefully through the information about installation of SQL Server, Administering SQL Server, Setting up clients, etc.

faq183-689, "What are SQL Books Online & Where Can I Find Them?" contains more info about SQL Books Online (SQL BOL) and where to find them.
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Goha]

I did a full search on my HD and i did not find the files
sqlserver.exe or the sqlmangr.exe. however i did find the Network Client Utility. here is some info that i found in it maight be usefull.

default network library : named pipes

I can select TCP/IP, Multiprotocol, NWlink IPX/SPX, appletalk, Banyan VINES, Named Pipes

 

[Guest_imported]

selhamawy,

I have the exact same problem as you. If you ever figure out how to setup a server inside a server group, could you let me know too?

lamd003@hotmail.com

Thanks

 

[tlbroadbent]

I'm confused. It appears that you did not install SQL Server on your PC. You did install the Client tools. Is this correct? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Guest_imported]

Figured it out. I needed to install the desktop version of SQL, not the other one. Now, with the desktop version installed, I have the service manager icon in the program group along with all the other stuff mentioned before.

So, selhamawy, you might want to try reinstalling and choosing the desktop version instead of the other one, whatever that was.

Dennis

 

[Goha]

lamd003
+ thanks. at least now i have one server to work off of.
-----
However I still have the problem of adding new servers. at the step where it says the available there is none listed. and if i put it in i get the same error message as before.

Helllllllpppppppppppppp!!

 

[Goha]

everyone- thanks for your input. I figured out the problem.

the server name had to be correctly configured in the client network utilities first. once i did that everything was a piece of cake.

 

[targis]

I think i'm having the same or close to the same problem.

I'm trying to install sql server 7.0 on windows 98.

I'm doing the full install and when I go into enterprise manager it's recognising my Pavilion Computer in SQL Server Group.
When I double click the Pavilion (Windows NT) Server icon I'm prompted to enter a Connect to Server Login and password.

I don't know what the login and password is because i'm just trying to install this on my windows 98 machine and not on an NT system.
If i try to enter a experimental login (sa) and password (admin), I get the following error:
A connection could not be established to Pavilion - General Network error- Check your network documentation. (ConnectionOpen(connect())
please verify sql server is running and check your sql server registration properties.

 

[MaffewW]

sa password is blank by default have you tried that

 

[MaffewW]

PS usually best to start a seperate thread rather than follow up old ones