Registration Problem

I tried to Register the SQL Express. I received the Email to comfirmation and verification but I don't received Any Key!

Can some one help me?

Thanks

Actually you don′t need to register within SQL Server Express, this will bring you only additional benefits like information about updates and other news about SQL Server (and as far as I can remeber some benefits), but since SQL Server Express is free you don′t even need to register nor need a license code.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Jens is correct, no key is needed. We do like people to register though; the registration process offers some benefits as well as the option to get updates about patches, etc. Registration also allows us to better understand how people are using SQL Express (there are a few questions), which helps me do a better job designing the next version of SQL Express.

Mike

|||

Is there a evaluation copy for SQL2005/ Reporting Server 2005? How Can we verify if we have installed a trial version? And how can this be permanetly activated?

Prasanna

vvprasanna@.yahoo.com

|||

Yes there is a trial version: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6931fa7f-c094-49a2-a050-2d07993566ec

Refer to the following snippet from the MS site:

Upgrading and Uninstalling the Trial Software

The 180-day trial version of SQL Server 2005 Enterprise Edition can be upgraded to the fully licensed version of SQL Server 2005 Enterprise Edition without uninstalling the trial software prior to the end of the 180-day period. If upgrading to the fully licensed version of SQL Server 2005 Standard Edition, Workgroup Edition, or Developer Edition, it is recommended that you uninstall the 180-day trial version of SQL Server 2005 Enterprise Edition before installing the fully licensed version of the other editions. Please refer to the product documentation for information about upgrading to the fully licensed software.

http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx

If you want to upgrade the product you should do that before the trial period has ended to avoid problems like this:
http://support.microsoft.com/kb/914158/en-us

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

It's also worth noting that SQL Express with Advanced Services includes Reporting Services free of charge. There are some limitation as is common with free products, but it might meet you needs. Check out the feature comparison by Edition.

Mike

Registration of SQL with WEB Server

i need to know how can i register my SQL server with WEb based SQL server

i have the address MSSQL2.MINUTESUAE.COM now how can i register my SQL Server with them.

when i m going to conect with this server it register but after that Database not show it take to much time.

Hi,

If you are trying to connect a shared database supplied by a hosting firm, to see your database in your Enterprise Manager will take really so long time.

I can advise you to connect your database by using Query Analyzer not Enterprise Manager.

You will connect your database directly if you use Query Analyzer.

Eralper

http://www.kodyaz.com

Registration error

Hi,
I am able to register other SQL server instances but when
I try to register one in particular I am getting this
error on the main server to which I need to register all
of the satelite servers. Can anyone help with this
problem? I don't understand why it is using a null
account instead of the guest account to try to log into
this particular instance.
Login failed for user '(null)'. Reason: Not associated
with a Trusted SQl Server connectionthat server is setup for Windows Authentication and you are logging in using
SQL login?
"Narine" <narinep@.siu.edu> wrote in message
news:2379e01c38c41$872a6010$a601280a@.phx.gbl...
> Hi,
> I am able to register other SQL server instances but when
> I try to register one in particular I am getting this
> error on the main server to which I need to register all
> of the satelite servers. Can anyone help with this
> problem? I don't understand why it is using a null
> account instead of the guest account to try to log into
> this particular instance.
>
> Login failed for user '(null)'. Reason: Not associated
> with a Trusted SQl Server connection|||I am just using windows authentication only because I am
using the datbase with MS VB.NET 2002 and I am doing
merge replication with subscribers.
>--Original Message--
>that server is setup for Windows Authentication and you
are logging in using
>SQL login?
>"Narine" <narinep@.siu.edu> wrote in message
>news:2379e01c38c41$872a6010$a601280a@.phx.gbl...
>> Hi,
>> I am able to register other SQL server instances but
when
>> I try to register one in particular I am getting this
>> error on the main server to which I need to register
all
>> of the satelite servers. Can anyone help with this
>> problem? I don't understand why it is using a null
>> account instead of the guest account to try to log into
>> this particular instance.
>>
>> Login failed for user '(null)'. Reason: Not associated
>> with a Trusted SQl Server connection
>
>.
>|||Check if the server you are trying to connect to is set to
Windows Authentication Only and change the security
settings to SQL Server and Windows. It seems that you are
using SQL authentication yourself and the other machine is
set to Windows Authentication only.
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>Hi,
>I am able to register other SQL server instances but when
>I try to register one in particular I am getting this
>error on the main server to which I need to register all
>of the satelite servers. Can anyone help with this
>problem? I don't understand why it is using a null
>account instead of the guest account to try to log into
>this particular instance.
>
>Login failed for user '(null)'. Reason: Not associated
>with a Trusted SQl Server connection
>.
>|||All of the servers are set to use Windows authentication
only originally when I installed them and this is stil so
when i just checked them. Could there be another reason
the main server is using the null account instead of the
guest account to register with the satelite server? How
can I set this parameter?
>--Original Message--
>Check if the server you are trying to connect to is set
to
>Windows Authentication Only and change the security
>settings to SQL Server and Windows. It seems that you
are
>using SQL authentication yourself and the other machine
is
>set to Windows Authentication only.
>
>Edgardo Valdez
>MCSD, MCDBA, MCSE, MCP+I
>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not associated
>>with a Trusted SQl Server connection
>>.
>.
>|||Check this article and see if it applies to you:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q279526
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>All of the servers are set to use Windows authentication
>only originally when I installed them and this is stil so
>when i just checked them. Could there be another reason
>the main server is using the null account instead of the
>guest account to register with the satelite server? How
>can I set this parameter?
>
>>--Original Message--
>>Check if the server you are trying to connect to is set
>to
>>Windows Authentication Only and change the security
>>settings to SQL Server and Windows. It seems that you
>are
>>using SQL authentication yourself and the other machine
>is
>>set to Windows Authentication only.
>>
>>Edgardo Valdez
>>MCSD, MCDBA, MCSE, MCP+I
>>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
>when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
>all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not associated
>>with a Trusted SQl Server connection
>>.
>>.
>.
>|||I have installed SP3 for MSSQL server for the desktop and
server version of mssql server 2000 and these included
the latest MDAC components. Should I go ahead and install
MDAC 8? could this be an SP3 problem? should I install
SP3a?
>--Original Message--
>Check this article and see if it applies to you:
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;Q279526
>
>Edgardo Valdez
>MCSD, MCDBA, MCSE, MCP+I
>http://www.edgardovaldez.us/
>>--Original Message--
>>All of the servers are set to use Windows
authentication
>>only originally when I installed them and this is stil
so
>>when i just checked them. Could there be another reason
>>the main server is using the null account instead of
the
>>guest account to register with the satelite server? How
>>can I set this parameter?
>>
>>--Original Message--
>>Check if the server you are trying to connect to is
set
>>to
>>Windows Authentication Only and change the security
>>settings to SQL Server and Windows. It seems that you
>>are
>>using SQL authentication yourself and the other
machine
>>is
>>set to Windows Authentication only.
>>
>>Edgardo Valdez
>>MCSD, MCDBA, MCSE, MCP+I
>>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
>>when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
>>all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log
into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not
associated
>>with a Trusted SQl Server connection
>>.
>>.
>>.
>.
>

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

You can use enterprise manager from sql 2005 to administer both sql 2000 and sql 2005 databases.

I doubt that the enterprise manager from sql 2000 would work with a sql 2005 database.

|||How should I use enterprise manager in SQL2005?|||

Its Management Studio.

From Management Studio, you can connect to both sql 2000 and sql 2005 databases.

http://www.aspfaq.com/sql2005/show.asp?id=3

|||this SQL Express, is there any stest I can use for SQL 2000?|||

Hi

Below is from previous link:

As for connecting to Express from application code, this should not be any different from connecting to a named instance of SQL Server 2000. Your connection string should look like this, assuming local machine and an instance name of SQLEXPRESS (you might need a different instance name, and you may have to use a machine name, rather than "." (which means local)).

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

you can't use it even if it registers.

here's a story:

i have bothe Enterprise manager and management studio on the same box

what ever i register on the management studio gets registered to EM.

but the problem is i cant open version 9 Db on EM even it i see it on the list of server

registering sql server problem

Trying to register a sql server in enterprise manager and
the server is on another domain which is trusted. The
server doesn't show up in the 'available servers' list
but I can register with ip address but *not* if I use
Client Network utility with exactly the correct netbios
name. Any ideas? Thanks.If the server isn't appearing in the list of available servers, chances are
that you need to add the IP address and server name to your hosts file. In
Win2k, the hosts file is located in c:\winnt\system32\driver\etc.
Open the hosts file in notepad, go to the end of the file, enter the IP
address, tab once and add the server name as follows:
xxx.xxx.xxx.xxx <tab> servername
John
"Dave Wilce" wrote:
> Trying to register a sql server in enterprise manager and
> the server is on another domain which is trusted. The
> server doesn't show up in the 'available servers' list
> but I can register with ip address but *not* if I use
> Client Network utility with exactly the correct netbios
> name. Any ideas? Thanks.
>|||We have tried 3 things :-
Using the Client Network utility does make the server
show up in the list but it will not register.
Using IP address it will allow registration but we hit
problems later (and we think it's because we use IP
address rather than NETBios name.
Using host file doesn't help...|||"Dave Wilce" wrote:
> We have tried 3 things :-
> Using the Client Network utility does make the server
> show up in the list but it will not register.
> Using IP address it will allow registration but we hit
> problems later (and we think it's because we use IP
> address rather than NETBios name.
> Using host file doesn't help...
Thinking out loud here...
Are you going through a firewall? Are you using the default port in the
Client Network utility (1433), and is the firewall open to that port? Can
you ping the other server using the server name? Can you have the your
network people make sure the server is listed in their DNS database correctly?
John

registering sql server problem

Trying to register a sql server in enterprise manager and
the server is on another domain which is trusted. The
server doesn't show up in the 'available servers' list
but I can register with ip address but *not* if I use
Client Network utility with exactly the correct netbios
name. Any ideas? Thanks.
If the server isn't appearing in the list of available servers, chances are
that you need to add the IP address and server name to your hosts file. In
Win2k, the hosts file is located in c:\winnt\system32\driver\etc.
Open the hosts file in notepad, go to the end of the file, enter the IP
address, tab once and add the server name as follows:
xxx.xxx.xxx.xxx <tab> servername
John
"Dave Wilce" wrote:

> Trying to register a sql server in enterprise manager and
> the server is on another domain which is trusted. The
> server doesn't show up in the 'available servers' list
> but I can register with ip address but *not* if I use
> Client Network utility with exactly the correct netbios
> name. Any ideas? Thanks.
>
|||We have tried 3 things :-
Using the Client Network utility does make the server
show up in the list but it will not register.
Using IP address it will allow registration but we hit
problems later (and we think it's because we use IP
address rather than NETBios name.
Using host file doesn't help...
|||"Dave Wilce" wrote:

> We have tried 3 things :-
> Using the Client Network utility does make the server
> show up in the list but it will not register.
> Using IP address it will allow registration but we hit
> problems later (and we think it's because we use IP
> address rather than NETBios name.
> Using host file doesn't help...
Thinking out loud here...
Are you going through a firewall? Are you using the default port in the
Client Network utility (1433), and is the firewall open to that port? Can
you ping the other server using the server name? Can you have the your
network people make sure the server is listed in their DNS database correctly?
John

registering sql server problem

Trying to register a sql server in enterprise manager and
the server is on another domain which is trusted. The
server doesn't show up in the 'available servers' list
but I can register with ip address but *not* if I use
Client Network utility with exactly the correct netbios
name. Any ideas? Thanks.If the server isn't appearing in the list of available servers, chances are
that you need to add the IP address and server name to your hosts file. In
Win2k, the hosts file is located in c:\winnt\system32\driver\etc.
Open the hosts file in notepad, go to the end of the file, enter the IP
address, tab once and add the server name as follows:
xxx.xxx.xxx.xxx <tab> servername
John
"Dave Wilce" wrote:

> Trying to register a sql server in enterprise manager and
> the server is on another domain which is trusted. The
> server doesn't show up in the 'available servers' list
> but I can register with ip address but *not* if I use
> Client Network utility with exactly the correct netbios
> name. Any ideas? Thanks.
>|||We have tried 3 things :-
Using the Client Network utility does make the server
show up in the list but it will not register.
Using IP address it will allow registration but we hit
problems later (and we think it's because we use IP
address rather than NETBios name.
Using host file doesn't help...|||"Dave Wilce" wrote:

> We have tried 3 things :-
> Using the Client Network utility does make the server
> show up in the list but it will not register.
> Using IP address it will allow registration but we hit
> problems later (and we think it's because we use IP
> address rather than NETBios name.
> Using host file doesn't help...
Thinking out loud here...
Are you going through a firewall? Are you using the default port in the
Client Network utility (1433), and is the firewall open to that port? Can
you ping the other server using the server name? Can you have the your
network people make sure the server is listed in their DNS database correctl
y?
John

Registering SQL Server

I m having 2 servers i wansted register the SQL server at one node
when i m registering the SQL server through SQL enterprises it showing the
error
"Unable to connect the sql server unavailable of does not exist"
what can be the problem
Yousuf Khan
Programmer
Hi
You could have typed in the wrong name, the server is not using the
protocols you have configured or ports/permissions are not set up correctly
to allow you to connect e.g. a firewall or restricted account.
Can you connect using Query Analyser?
You may want to try specifying the IP address instead if the name?
John
"Yousuf" wrote:

> I m having 2 servers i wansted register the SQL server at one node
> when i m registering the SQL server through SQL enterprises it showing the
> error
> "Unable to connect the sql server unavailable of does not exist"
> what can be the problem
> --
> Yousuf Khan
> Programmer
|||both the systems are using the same prtocols(NetBeui) and i dont have any
firwall
both systems are having win nt and i m able to make turusties for each other
but not able to connect sql
Yousuf Khan
Programmer
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You could have typed in the wrong name, the server is not using the
> protocols you have configured or ports/permissions are not set up correctly
> to allow you to connect e.g. a firewall or restricted account.
> Can you connect using Query Analyser?
> You may want to try specifying the IP address instead if the name?
> John
>
> "Yousuf" wrote:

Registering SQL Server

I m having 2 servers i wansted register the SQL server at one node
when i m registering the SQL server through SQL enterprises it showing the
error
"Unable to connect the sql server unavailable of does not exist"
what can be the problem
--
Yousuf Khan
ProgrammerHi
You could have typed in the wrong name, the server is not using the
protocols you have configured or ports/permissions are not set up correctly
to allow you to connect e.g. a firewall or restricted account.
Can you connect using Query Analyser?
You may want to try specifying the IP address instead if the name?
John
"Yousuf" wrote:

> I m having 2 servers i wansted register the SQL server at one node
> when i m registering the SQL server through SQL enterprises it showing the
> error
> "Unable to connect the sql server unavailable of does not exist"
> what can be the problem
> --
> Yousuf Khan
> Programmer|||both the systems are using the same prtocols(NetBeui) and i dont have any
firwall
both systems are having win nt and i m able to make turusties for each other
but not able to connect sql
--
Yousuf Khan
Programmer
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You could have typed in the wrong name, the server is not using the
> protocols you have configured or ports/permissions are not set up correctl
y
> to allow you to connect e.g. a firewall or restricted account.
> Can you connect using Query Analyser?
> You may want to try specifying the IP address instead if the name?
> John
>
> "Yousuf" wrote:
>

Registering SQL SERVER

Hi,
How to register a Remote SQL SERVER from a node in Local Area Network?You need to set up a linked server. See Linked Server in Books Online. If you need more help, let us know.

Registering SQL Server

I m having 2 servers i wansted register the SQL server at one node
when i m registering the SQL server through SQL enterprises it showing the
error
"Unable to connect the sql server unavailable of does not exist"
what can be the problem
--
Yousuf Khan
ProgrammerHi
You could have typed in the wrong name, the server is not using the
protocols you have configured or ports/permissions are not set up correctly
to allow you to connect e.g. a firewall or restricted account.
Can you connect using Query Analyser?
You may want to try specifying the IP address instead if the name?
John
"Yousuf" wrote:
> I m having 2 servers i wansted register the SQL server at one node
> when i m registering the SQL server through SQL enterprises it showing the
> error
> "Unable to connect the sql server unavailable of does not exist"
> what can be the problem
> --
> Yousuf Khan
> Programmer|||both the systems are using the same prtocols(NetBeui) and i dont have any
firwall
both systems are having win nt and i m able to make turusties for each other
but not able to connect sql
--
Yousuf Khan
Programmer
"John Bell" wrote:
> Hi
> You could have typed in the wrong name, the server is not using the
> protocols you have configured or ports/permissions are not set up correctly
> to allow you to connect e.g. a firewall or restricted account.
> Can you connect using Query Analyser?
> You may want to try specifying the IP address instead if the name?
> John
>
> "Yousuf" wrote:
> > I m having 2 servers i wansted register the SQL server at one node
> > when i m registering the SQL server through SQL enterprises it showing the
> > error
> > "Unable to connect the sql server unavailable of does not exist"
> > what can be the problem
> > --
> > Yousuf Khan
> > Programmer|||Hi,
Can you connect to an administrative share eg \\server_name\c$ ?
Can you launch Enterprise Manager on the server and connect to the local
instance? Can you connect EM on one SQL Server to the other SQL Server?
Do you know which network library SQL Server is using? I didn't know that
it could use NetBEUI so if the servers are communicating only on NetBEUI and
SQL Server is communicating on Named Pipes or TCP/IP, might this not cause a
problem?
Cheers,
IM|||I am able to conncet to local machine EM not able to other server, i am using
netbeui protocol through Win NT i m getting his share and users but not
getting conneted to sql server
--
Yousuf Khan
Programmer
"Ian Murphy" wrote:
> Hi,
> Can you connect to an administrative share eg \\server_name\c$ ?
> Can you launch Enterprise Manager on the server and connect to the local
> instance? Can you connect EM on one SQL Server to the other SQL Server?
> Do you know which network library SQL Server is using? I didn't know that
> it could use NetBEUI so if the servers are communicating only on NetBEUI and
> SQL Server is communicating on Named Pipes or TCP/IP, might this not cause a
> problem?
> Cheers,
> IM

Registering SQL Server

Hi,
I need to register to a SQL Serve that is part of our Network but is on a
different Subnet Mask and Default Gateway IP Range.
This is not working. But I can access the Server remotely using remote login
tools.
Is there anything I need to do on the security side of SQL Server in order
for to be able to register to it? This would make my life a lot easier.
Thanks In Advance,
Kevin.Kevin,
There might be a firewall causing that. Try telnetting <ip_address>:1433, if
that doesn't work you need to open it.
Jon Jahren
"Kevin Humphreys" <khumphreys@.hotmail.com> wrote in message
news:OL7gXi#xEHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I need to register to a SQL Serve that is part of our Network but is on a
> different Subnet Mask and Default Gateway IP Range.
> This is not working. But I can access the Server remotely using remote
login
> tools.
> Is there anything I need to do on the security side of SQL Server in order
> for to be able to register to it? This would make my life a lot easier.
> Thanks In Advance,
> Kevin.
>|||Even better how do I register to a SQL Server using the Server's local
system account.
"Kevin Humphreys" <khumphreys@.hotmail.com> wrote in message
news:OL7gXi%23xEHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I need to register to a SQL Serve that is part of our Network but is on a
> different Subnet Mask and Default Gateway IP Range.
> This is not working. But I can access the Server remotely using remote
> login tools.
> Is there anything I need to do on the security side of SQL Server in order
> for to be able to register to it? This would make my life a lot easier.
> Thanks In Advance,
> Kevin.
>|||You would do this when logged onto the SQL Server box and it
would work for Enterprise Manager on the SQL Server box
only. It's a local account...local to that box only.
You won't accomplish much with that. What you may be
thinking is another approach where your login is added as a
local administrator on the SQL Server box. Then you register
the SQL Server with your login. That's similar to what it
sounds like you are asking for.
-Sue
On Thu, 11 Nov 2004 13:59:45 -0000, "Kevin Humphreys"
<khumphreys@.hotmail.com> wrote:

>Even better how do I register to a SQL Server using the Server's local
>system account.
>"Kevin Humphreys" <khumphreys@.hotmail.com> wrote in message
>news:OL7gXi%23xEHA.2212@.TK2MSFTNGP15.phx.gbl...
>

Registering servers in Enterprise Manager.

Is there any way I can reload the list of servers I
registered through Enterprise Manager, so that I don't
have to register them manually. I have approx. 80 servers
registered with Enterprise manager on my old workstation
and now I want them on my new workstation.
Or to put this question otherway: where does enterprise
manager store the information of servers registered with
it?
Any suggestions welcome. Thanks. -- Adi ..you can use
sp_addlinkedserver (parms)
in the query analyzer
"Adi" <adibazz_nospam@.hotmail.com> wrote in message
news:6caf01c35867$6610d200$a001280a@.phx.gbl...
> Is there any way I can reload the list of servers I
> registered through Enterprise Manager, so that I don't
> have to register them manually. I have approx. 80 servers
> registered with Enterprise manager on my old workstation
> and now I want them on my new workstation.
> Or to put this question otherway: where does enterprise
> manager store the information of servers registered with
> it?
> Any suggestions welcome. Thanks. -- Adi ..|||What do you use to manage these 80 servers please. I will
like to know.
Thanks,
Aboki.
>--Original Message--
>Is there any way I can reload the list of servers I
>registered through Enterprise Manager, so that I don't
>have to register them manually. I have approx. 80 servers
>registered with Enterprise manager on my old workstation
>and now I want them on my new workstation.
>Or to put this question otherway: where does enterprise
>manager store the information of servers registered with
>it?
>Any suggestions welcome. Thanks. -- Adi ..
>.
>|||Thanks for your reply but I am talking here for
registering the server (and that through Enterprise
Manager). -- Adi ..
>--Original Message--
>you can use
>sp_addlinkedserver (parms)
>in the query analyzer
>"Adi" <adibazz_nospam@.hotmail.com> wrote in message
>news:6caf01c35867$6610d200$a001280a@.phx.gbl...
>> Is there any way I can reload the list of servers I
>> registered through Enterprise Manager, so that I don't
>> have to register them manually. I have approx. 80
servers
>> registered with Enterprise manager on my old workstation
>> and now I want them on my new workstation.
>> Or to put this question otherway: where does enterprise
>> manager store the information of servers registered with
>> it?
>> Any suggestions welcome. Thanks. -- Adi ..
>
>.
>|||if you want do batch mode then instead of using the enterprise manager you
use the query analyzer and use the Sp.
if you use the enterprise you need to do manually, one at a time.
"Adi." <adibazz_nospam@.hotmail.com> wrote in message
news:01d701c3586f$8b7e9a10$a601280a@.phx.gbl...
> Thanks for your reply but I am talking here for
> registering the server (and that through Enterprise
> Manager). -- Adi ..
> >--Original Message--
> >you can use
> >sp_addlinkedserver (parms)
> >
> >in the query analyzer
> >
> >"Adi" <adibazz_nospam@.hotmail.com> wrote in message
> >news:6caf01c35867$6610d200$a001280a@.phx.gbl...
> >> Is there any way I can reload the list of servers I
> >> registered through Enterprise Manager, so that I don't
> >> have to register them manually. I have approx. 80
> servers
> >> registered with Enterprise manager on my old workstation
> >> and now I want them on my new workstation.
> >>
> >> Or to put this question otherway: where does enterprise
> >> manager store the information of servers registered with
> >> it?
> >>
> >> Any suggestions welcome. Thanks. -- Adi ..
> >
> >
> >.
> >

Registering Servers

In Enterprise Manager 2000 I was able to register multiple servers and next
time I opened it those servers would automatically connect. With SQL Server
Management Studio 2005 I can register multiple servers, but next time I open
it only the last one I had connected shows. Is there a way to maintain
multiple connections?
Hi Gary
I believe the object browser will show the server that you have logged into,
you will need to log into the other servers to get them in object explorer.
You want to raise this as an request at
http://lab.msdn.microsoft.com/produc...k/default.aspx
John
"Gary L" wrote:

> In Enterprise Manager 2000 I was able to register multiple servers and next
> time I opened it those servers would automatically connect. With SQL Server
> Management Studio 2005 I can register multiple servers, but next time I open
> it only the last one I had connected shows. Is there a way to maintain
> multiple connections?

Registering Servers

In Enterprise Manager 2000 I was able to register multiple servers and next
time I opened it those servers would automatically connect. With SQL Server
Management Studio 2005 I can register multiple servers, but next time I open
it only the last one I had connected shows. Is there a way to maintain
multiple connections?Hi Gary
I believe the object browser will show the server that you have logged into,
you will need to log into the other servers to get them in object explorer.
You want to raise this as an request at
http://lab.msdn.microsoft.com/produ...ck/default.aspx
John
"Gary L" wrote:

> In Enterprise Manager 2000 I was able to register multiple servers and nex
t
> time I opened it those servers would automatically connect. With SQL Serv
er
> Management Studio 2005 I can register multiple servers, but next time I op
en
> it only the last one I had connected shows. Is there a way to maintain
> multiple connections?

Registering Servers

In Enterprise Manager 2000 I was able to register multiple servers and next
time I opened it those servers would automatically connect. With SQL Server
Management Studio 2005 I can register multiple servers, but next time I open
it only the last one I had connected shows. Is there a way to maintain
multiple connections?Hi Gary
I believe the object browser will show the server that you have logged into,
you will need to log into the other servers to get them in object explorer.
You want to raise this as an request at
http://lab.msdn.microsoft.com/productfeedback/default.aspx
John
"Gary L" wrote:
> In Enterprise Manager 2000 I was able to register multiple servers and next
> time I opened it those servers would automatically connect. With SQL Server
> Management Studio 2005 I can register multiple servers, but next time I open
> it only the last one I had connected shows. Is there a way to maintain
> multiple connections?

Registering MSDE 2000 in EM

Greetings,
anyone knows how to register MSDE 2000 SP3 in EM?
Thank you,
Aleksandar Andjelkovic
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Hi,
MSDE is not coming with client tools like Enterprise manager, Query
analyzer. To utilize that
you need to purchase the client access license.
FYI, if you have the license already then you can install the client and
register the MSDE server.
Have a look into the below links for the details and free tools to access
MSDE.
http://www.aspfaq.com/show.asp?id=2442
Thanks
Hari
MCDBA
<Aleksandar Andjelkovic> wrote in message
news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||Just register it. Note that MSDE doesn't listen to any netlib by default, you have to configure that.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Aleksandar Andjelkovic> wrote in message news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thank you for your replay. I found the answer, MSDE is visible on the
network now, and I was able to register it in EM. I was missing
DISABLENETWORKPROTOCOLS=0 in setup command when installing MSDE.
Here is the link:
http://www.experts-exchange.com/Data...rver/Q_2067987
3.html
Thank you, Aleksandar
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Registering MSDE 2000 in EM

Greetings,
anyone knows how to register MSDE 2000 SP3 in EM?
Thank you,
Aleksandar Andjelkovic
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Hi,
MSDE is not coming with client tools like Enterprise manager, Query
analyzer. To utilize that
you need to purchase the client access license.
FYI, if you have the license already then you can install the client and
register the MSDE server.
Have a look into the below links for the details and free tools to access
MSDE.
http://www.aspfaq.com/show.asp?id=2442
Thanks
Hari
MCDBA
<Aleksandar Andjelkovic> wrote in message
news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Just register it. Note that MSDE doesn't listen to any netlib by default, yo
u have to configure that.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Aleksandar Andjelkovic> wrote in message news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...[vbco
l=seagreen]
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it![/vbcol]|||Thank you for your replay. I found the answer, MSDE is visible on the
network now, and I was able to register it in EM. I was missing
DISABLENETWORKPROTOCOLS=0 in setup command when installing MSDE.
Here is the link:
http://www.experts-exchange.com/Dat...erver/Q_2067987
3.html
Thank you, Aleksandar
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Registering MSDE 2000 in EM

Greetings,
anyone knows how to register MSDE 2000 SP3 in EM?
Thank you,
Aleksandar Andjelkovic
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!Hi,
MSDE is not coming with client tools like Enterprise manager, Query
analyzer. To utilize that
you need to purchase the client access license.
FYI, if you have the license already then you can install the client and
register the MSDE server.
Have a look into the below links for the details and free tools to access
MSDE.
http://www.aspfaq.com/show.asp?id=2442
Thanks
Hari
MCDBA
<Aleksandar Andjelkovic> wrote in message
news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Just register it. Note that MSDE doesn't listen to any netlib by default, you have to configure that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Aleksandar Andjelkovic> wrote in message news:eY2Hr9GTEHA.3016@.tk2msftngp13.phx.gbl...
> Greetings,
> anyone knows how to register MSDE 2000 SP3 in EM?
> Thank you,
> Aleksandar Andjelkovic
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!