sql report manager: register

Showing posts with label register. Show all posts

Thursday, March 8, 2012

cant register to server from client

When I register to SQL server 2000 on another machine, I
get message " SQL server doesn't exist or access is
denied. Connection open". The pinging of the two machines
is OK. And I checked the protocols of both machines were
the same. Tell me how to rectify this problem. ThanksAre you trying to register by IP or by Name? There is an entry for the
server in the Client Configuration Utility? There is an entry for the server
in the DNS or in your hosts file?
regards,
Srgio Monteiro - Brasil
www.sqlpass.org
"Lie" <anonymous@.discussions.microsoft.com> escreveu na mensagem
news:378201c3dcc8$bbe0d5f0$3101280a@.phx.gbl...

quote:

> When I register to SQL server 2000 on another machine, I
> get message " SQL server doesn't exist or access is
> denied. Connection open". The pinging of the two machines
> is OK. And I checked the protocols of both machines were
> the same. Tell me how to rectify this problem. Thanks

|||You need to retrieve the actual OS error to troubleshoot this problem.
Reply with the OS error returned while connecting using an ODBC test DSN.
Or test using ISQL.exe from a command prompt.
Example:
ISQL -Stcp:ServerNameHere -Usqluseridhere -Ppasswordhere -Q"select
@.@.version"
or
ISQL -Stcp:ServerNameHere -E -Q"select @.@.version"
Search the kb for the OS error returned.
Example:
10060 == Connection Timeout
10061 == Connection Refused. The server is not listening on TCP. This
could be caused if we fail to bind to the port.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Cant register to a named instance

2nd instance of sql was sucessfully installed on the 2nd node of the
cluster. However if i try to register on this 2nd instance it failes with
msg as sql server does not exists or access denied. I tried with the Ip
address too but it fails with same error. I havent installed sp3a on this
instance was trying to get the instance up and running but the initial step
only fails. Has anyone seen this before. any help will be greatly
appreciated. TIA
Message posted via http://www.sqlmonster.com
Hive you seen
http://msdn.microsoft.com/library/de...eInstances.asp ?
Peter
"I favor the Civil Rights Act of 1964 and it must be enforced at gunpoint if
necessary."
Ronald Reagan
"ishaan99 via SQLMonster.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>
|||Hi
You might need to add an alias using the SQL Server client network utility.
You can find it in your SQL Server programs group.
What you need to put in depends on your network protocols. We use either
TCP/IP or named pipes. For TCP/IP you need to supply 'server name\instance
name' and the port that SQL Server is running on. For named pipes supply the
server name\instance name.
You then should be able to access the named instance.
Hope this helps
John
"ishaan99 via SQLMonster.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>
|||Thanks but I did try adding an alias from client n/w . also tried using
osql with servername\instancename but i get the same error. However I could
see 2nd instance of sql server and sql agent running from 2nd node services
though. My 2nd node accesses 4 drives and i have all system files on one of
these 4 drives but MSSQL$2INSTANCE is under c:\ProgramFiles.... Has it got
anyting to do with installation? Since i am not able to isql to this server
I feel is sql itself is failing.. any thoughts on this?
Message posted via http://www.sqlmonster.com
|||This what i see after trying from osql
Unable to connect: SQL Server is unavailable or does not exists. Net-
library error 2: ConnectionOpen (Connect())
Message posted via http://www.sqlmonster.com
|||Have you looked at the SQL Server logs.
It should tell what types of client connections can be made (if you are
using TCP/IP what ports are being used etc).
e.g. my log has the following lines in it
SQL server listening on 127.0.0.1: 2433
SQL server listening on 169.254.151.241: 2433
...
SQL server listening on TCP, Shared Memory, Named Pipes
"ishaan99 via SQLMonster.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>

Cant register to a named instance

2nd instance of sql was sucessfully installed on the 2nd node of the
cluster. However if i try to register on this 2nd instance it failes with
msg as sql server does not exists or access denied. I tried with the Ip
address too but it fails with same error. I havent installed sp3a on this
instance was trying to get the instance up and running but the initial step
only fails. Has anyone seen this before. any help will be greatly
appreciated. TIA
--
Message posted via http://www.sqlmonster.comHive you seen
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/MultipleInstances.asp ?
Peter
"I favor the Civil Rights Act of 1964 and it must be enforced at gunpoint if
necessary."
Ronald Reagan
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>|||Hi
You might need to add an alias using the SQL Server client network utility.
You can find it in your SQL Server programs group.
What you need to put in depends on your network protocols. We use either
TCP/IP or named pipes. For TCP/IP you need to supply 'server name\instance
name' and the port that SQL Server is running on. For named pipes supply the
server name\instance name.
You then should be able to access the named instance.
Hope this helps
John
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>|||Thanks but I did try adding an alias from client n/w . also tried using
osql with servername\instancename but i get the same error. However I could
see 2nd instance of sql server and sql agent running from 2nd node services
though. My 2nd node accesses 4 drives and i have all system files on one of
these 4 drives but MSSQL$2INSTANCE is under c:\ProgramFiles.... Has it got
anyting to do with installation? Since i am not able to isql to this server
I feel is sql itself is failing.. any thoughts on this'
--
Message posted via http://www.sqlmonster.com|||This what i see after trying from osql
Unable to connect: SQL Server is unavailable or does not exists. Net-
library error 2: ConnectionOpen (Connect())
--
Message posted via http://www.sqlmonster.com|||Have you looked at the SQL Server logs.
It should tell what types of client connections can be made (if you are
using TCP/IP what ports are being used etc).
e.g. my log has the following lines in it
SQL server listening on 127.0.0.1: 2433
SQL server listening on 169.254.151.241: 2433
...
SQL server listening on TCP, Shared Memory, Named Pipes
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>

Wednesday, March 7, 2012

Cant register to a named instance

2nd instance of sql was sucessfully installed on the 2nd node of the
cluster. However if i try to register on this 2nd instance it failes with
msg as sql server does not exists or access denied. I tried with the Ip
address too but it fails with same error. I havent installed sp3a on this
instance was trying to get the instance up and running but the initial step
only fails. Has anyone seen this before. any help will be greatly
appreciated. TIA
Message posted via http://www.droptable.comHive you seen
http://msdn.microsoft.com/library/d...leInstances.asp ?
Peter
"I favor the Civil Rights Act of 1964 and it must be enforced at gunpoint if
necessary."
Ronald Reagan
"ishaan99 via droptable.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial ste
p
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.droptable.com
>|||Hi
You might need to add an alias using the SQL Server client network utility.
You can find it in your SQL Server programs group.
What you need to put in depends on your network protocols. We use either
TCP/IP or named pipes. For TCP/IP you need to supply 'server name\instance
name' and the port that SQL Server is running on. For named pipes supply the
server name\instance name.
You then should be able to access the named instance.
Hope this helps
John
"ishaan99 via droptable.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial ste
p
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.droptable.com
>|||Thanks but I did try adding an alias from client n/w . also tried using
osql with servername\instancename but i get the same error. However I could
see 2nd instance of sql server and sql agent running from 2nd node services
though. My 2nd node accesses 4 drives and i have all system files on one of
these 4 drives but MSSQL$2INSTANCE is under c:\ProgramFiles.... Has it got
anyting to do with installation? Since i am not able to isql to this server
I feel is sql itself is failing.. any thoughts on this'
Message posted via http://www.droptable.com|||This what i see after trying from osql
Unable to connect: SQL Server is unavailable or does not exists. Net-
library error 2: ConnectionOpen (Connect())
Message posted via http://www.droptable.com|||Have you looked at the SQL Server logs.
It should tell what types of client connections can be made (if you are
using TCP/IP what ports are being used etc).
e.g. my log has the following lines in it
SQL server listening on 127.0.0.1: 2433
SQL server listening on 169.254.151.241: 2433
...
SQL server listening on TCP, Shared Memory, Named Pipes
"ishaan99 via droptable.com" wrote:

> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial ste
p
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.droptable.com
>

Can't register SSIS server in SMS...need permissions help.

I have a user who can't register the SSIS server in SMS. What permissions do I need to give him to allow this ... without making him sysadmin of course?

Check out the article by Kirk Haselden @. http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

Thanks,
Loonysan

|||

Yes, I found this online.

Unfortunately, after all this I'm still getting an error.

Could not get proxy data for proxy_id = 1

When I set up the credential, what kind of account should the "identity" be? SQL or Windows? What kind of permission should the "identity" have?

Can't Register SQLServer in Enterprise Manager

I have been trying to register a SQL server in my server
group in Enterprise Manager but it cannot find the
server. The SQL server (SQLServer2k) resides on a server
machine running WinServer2K. I am trying to gain access
from a remote PC running Win2k.
I am able to see the server in the list of available
servers when I run the registration wizard. But when I
finish the wizard it fails to establish a connection. I
have double checked login ID and password. I even set up
another instance of a SQL server on the server machine.
When I start the wizard again to register the new server,
I see the new server in the available list but I can't
connect to it either.
I uninstalled and reinstalled SQLServer2k on both the
server and the client PC. Still no luck. I can establish
ethernet connection between the two machines so it doesn't
appear to be a network problem, especially when I can see
the servers in my availability list.
Any ideas on why this is happening and how to fix?
Roger.
We had some issues in our group, where the default database specified in the
Login was no longer attached to the SQL Server.
This caused the Server Registration to fail.
HTH, Amol.
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:92c101c43367$84ec1910$a501280a@.phx.gbl...
> I have been trying to register a SQL server in my server
> group in Enterprise Manager but it cannot find the
> server. The SQL server (SQLServer2k) resides on a server
> machine running WinServer2K. I am trying to gain access
> from a remote PC running Win2k.
> I am able to see the server in the list of available
> servers when I run the registration wizard. But when I
> finish the wizard it fails to establish a connection. I
> have double checked login ID and password. I even set up
> another instance of a SQL server on the server machine.
> When I start the wizard again to register the new server,
> I see the new server in the available list but I can't
> connect to it either.
> I uninstalled and reinstalled SQLServer2k on both the
> server and the client PC. Still no luck. I can establish
> ethernet connection between the two machines so it doesn't
> appear to be a network problem, especially when I can see
> the servers in my availability list.
> Any ideas on why this is happening and how to fix?
> Roger.
>

Can't Register SQLServer in Enterprise Manager

I have been trying to register a SQL server in my server
group in Enterprise Manager but it cannot find the
server. The SQL server (SQLServer2k) resides on a server
machine running WinServer2K. I am trying to gain access
from a remote PC running Win2k.
I am able to see the server in the list of available
servers when I run the registration wizard. But when I
finish the wizard it fails to establish a connection. I
have double checked login ID and password. I even set up
another instance of a SQL server on the server machine.
When I start the wizard again to register the new server,
I see the new server in the available list but I can't
connect to it either.
I uninstalled and reinstalled SQLServer2k on both the
server and the client PC. Still no luck. I can establish
ethernet connection between the two machines so it doesn't
appear to be a network problem, especially when I can see
the servers in my availability list.
Any ideas on why this is happening and how to fix?
Roger.We had some issues in our group, where the default database specified in the
Login was no longer attached to the SQL Server.
This caused the Server Registration to fail.
HTH, Amol.
"Roger Denison" <anonymous@.discussions.microsoft.com> wrote in message
news:92c101c43367$84ec1910$a501280a@.phx.gbl...
> I have been trying to register a SQL server in my server
> group in Enterprise Manager but it cannot find the
> server. The SQL server (SQLServer2k) resides on a server
> machine running WinServer2K. I am trying to gain access
> from a remote PC running Win2k.
> I am able to see the server in the list of available
> servers when I run the registration wizard. But when I
> finish the wizard it fails to establish a connection. I
> have double checked login ID and password. I even set up
> another instance of a SQL server on the server machine.
> When I start the wizard again to register the new server,
> I see the new server in the available list but I can't
> connect to it either.
> I uninstalled and reinstalled SQLServer2k on both the
> server and the client PC. Still no luck. I can establish
> ethernet connection between the two machines so it doesn't
> appear to be a network problem, especially when I can see
> the servers in my availability list.
> Any ideas on why this is happening and how to fix?
> Roger.
>

Can't register SQL-DMO

Hi, this is an old issue and i've searched for days. I have a vb6 app thats
worked for years on a NT4/SQL7 server using the SQL7 client. We are finally
moving out of mixed mode and upgraded the server to NT2003/SQL 2000.
I upgraded and re-compiled the vb program and installed it on the users PC,
along with the sql2000 client. I would get an error connecting to the sql
2000 server. [Microsoft][ODBC SQL Server Drver][SQL Server]You must upgrade
your SQL Enterprise Manager and SQL-DMO(SQL OLE) to SQL 2000 (SQLDMO) to
connect to this server. Error Code -2147220990
After much research I found that I needed to install/register the SQL-DMO
and found a article (326613) from Microsoft on how to create a distribution
package.
I followed the instructions and the sql-dmo package worked fine, ON some
machines (XP), but I've found that many NT2000 PC's it simply won't install
and register on. It will come back with a HResult -2147024770 failed to
register sqldmo.dll
I've got all the files in the right place, with the .rll files where they
need to be. I can't even manually register the sqldmo.dll file on these
PC's.. The really strange part is if I install the full sql2000 server onto
the PC then the program runs fine. BUT, as soon as I uninstall the server
portion it fails again. I've tried installing both the SQL-2000 client and
client tools but nothing works short of a full SQL server install, Which is
not an option!
The PC's in question are all Compaq/HP EVO's running NT2000, standard fair
stuff, nothing strange on the desktop. All have the lastest updates, patches
and hotfixes.
I know this is an old issue, But does anybody have a clue? I'd hate to
tell my boss that those folks can't run the program unless they upgrade there
PC.
Im not sure if my dev system has service pack 4 or not, I'll have to check.
As far as being compiled with the newest MSVc++ runtime linked
lib,"msvcr71.dll I am using .net 2002 so I guess not. Strange that the
microsoft article (326613) says nothing about this. as far as the rest of
your statement all those files are included and in their correct directory
structure, Per the article I used to create the distribution package.
"Andrea Montanari" wrote:

> hi,
> jcw wrote:
> what files are you "redistributing" in order to install SQL-DMO 2000?
> In my experience, I never failed providing
> ;SQL Server service pack 4 SQL-DMO object has been compiled with the newest
> Microsoft Visual C++ runtime linked library, msvcr71.dll that must be
> redistributed as well;
> ...\WINDOWS\SYSTEM\msvcr71.dll DestDir: WinSys ; sharedfile
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\WINDOWS\SYSTEM\odbcbcp.dll; DestDir: WinSys ; sharedfile
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\WINDOWS\SYSTEM\sqlwoa.dll ; DestDir: WinSys
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\WINDOWS\SYSTEM\sqlwid.dll ; DestDir: WinSys
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\w95scm.dll; DestDir:
> DestinationFolder\Binn
> ...\WINDOWS\SYSTEM\sqlunirl.dll ; DestDir: WinSys
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlresld.dll; DestDir:
> DestinationFolder\Binn
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlsvc.dll; DestDir:
> DestinationFolder\Binn
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlsvc.RLL;
> DestDir: DestinationFolder\Binn\Resources\1033
> ; not licensed by redist.txt but available after installation of MDAC2.6
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Sqldmo.rll;
> DestDir: DestinationFolder\Binn\Resources\1033
> ...\Programmi\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll; DestDir:
> DestinationFolder\Binn ; file to be registered via regserver
> DestinationFolder can either be the installation directory of one instance
> of Microsoft SQLServer 2000, like ..\Program Files\Microsoft SQL
> Server\80\Tools, even if no istance of SQL Server has been installed, or the
> installation directory of your application, but the first one is preferred.
> Please do respect the hierarchy \Binn\Resources\1033 (where 1033 specifies
> the language), where needed, in order to grant correct functionality of
> Ole-Automation objects.
> In order to install SQL-DMO components for MSDE 2000, Microsoft Internet
> Explorer 5.5 or higher is required.
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||checked and I did install the SP4.

cant register sql2k5

I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
--
TIA,
ChrisRDid you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
--
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
> > I have a local instance of sql2k5, as well as a remote one. From my local
> > Management Studio, I try to register the remote one, and I get the message...
> >
> > A connection was successfully established to the server, but then an error
> > occured during the login process. (provider: TCP Provider, error:0 - An
> > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > 10054)
> >
> > Any ideas?
> > --
> > TIA,
> > ChrisR
>|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
> > Did you enable TCP/IP connections from remote machines in SQL Surface
> > Area Configuration Tool? They're not turned on by default in 2005.
> >
> > ChrisR wrote:
> > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > Management Studio, I try to register the remote one, and I get the message...
> > >
> > > A connection was successfully established to the server, but then an error
> > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > 10054)
> > >
> > > Any ideas?
> > > --
> > > TIA,
> > > ChrisR
> >
> >|||Start\ Programs\ there is no Configuration Tools option.
--
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
--
TIA,
ChrisR
"ChrisR" wrote:
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> > Configuration tool?
> >
> > "ChrisR" wrote:
> >
> > > I don't have a Configurations tab on the remote box... I just realized its
> > > Beta2. Could this have sometihng to do with it?
> > > --
> > > TIA,
> > > ChrisR
> > >
> > >
> > > "Corey Bunch" wrote:
> > >
> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > > Area Configuration Tool? They're not turned on by default in 2005.
> > > >
> > > > ChrisR wrote:
> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > > Management Studio, I try to register the remote one, and I get the message...
> > > > >
> > > > > A connection was successfully established to the server, but then an error
> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > > 10054)
> > > > >
> > > > > Any ideas?
> > > > > --
> > > > > TIA,
> > > > > ChrisR
> > > >
> > > >|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
>> Start\ Programs\ there is no Configuration Tools option.
>> --
>> TIA,
>> ChrisR
>>
>> "burt_king" wrote:
>> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> > Configuration tool?
>> >
>> > "ChrisR" wrote:
>> >
>> > > I don't have a Configurations tab on the remote box... I just realized its
>> > > Beta2. Could this have sometihng to do with it?
>> > > --
>> > > TIA,
>> > > ChrisR
>> > >
>> > >
>> > > "Corey Bunch" wrote:
>> > >
>> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> > > >
>> > > > ChrisR wrote:
>> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> > > > > Management Studio, I try to register the remote one, and I get the message...
>> > > > >
>> > > > > A connection was successfully established to the server, but then an error
>> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> > > > > 10054)
>> > > > >
>> > > > > Any ideas?
>> > > > > --
>> > > > > TIA,
>> > > > > ChrisR
>> > > >
>> > > >|||And do what to the netlibs? I dont see anything like enable remote connections.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "ChrisR" wrote:
> >
> >> Start\ Programs\ there is no Configuration Tools option.
> >> --
> >> TIA,
> >> ChrisR
> >>
> >>
> >> "burt_king" wrote:
> >>
> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> > Configuration tool?
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> > > Beta2. Could this have sometihng to do with it?
> >> > > --
> >> > > TIA,
> >> > > ChrisR
> >> > >
> >> > >
> >> > > "Corey Bunch" wrote:
> >> > >
> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> > > >
> >> > > > ChrisR wrote:
> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> > > > >
> >> > > > > A connection was successfully established to the server, but then an error
> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> > > > > 10054)
> >> > > > >
> >> > > > > Any ideas?
> >> > > > > --
> >> > > > > TIA,
> >> > > > > ChrisR
> >> > > >
> >> > > >
>|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
>> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
>> Here
>> you can enable the netlibs.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
>> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
>> >
>> > --
>> > TIA,
>> > ChrisR
>> >
>> >
>> > "ChrisR" wrote:
>> >
>> >> Start\ Programs\ there is no Configuration Tools option.
>> >> --
>> >> TIA,
>> >> ChrisR
>> >>
>> >>
>> >> "burt_king" wrote:
>> >>
>> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> >> > Configuration tool?
>> >> >
>> >> > "ChrisR" wrote:
>> >> >
>> >> > > I don't have a Configurations tab on the remote box... I just realized its
>> >> > > Beta2. Could this have sometihng to do with it?
>> >> > > --
>> >> > > TIA,
>> >> > > ChrisR
>> >> > >
>> >> > >
>> >> > > "Corey Bunch" wrote:
>> >> > >
>> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> >> > > >
>> >> > > > ChrisR wrote:
>> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> >> > > > > Management Studio, I try to register the remote one, and I get the message...
>> >> > > > >
>> >> > > > > A connection was successfully established to the server, but then an error
>> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> >> > > > > 10054)
>> >> > > > >
>> >> > > > > Any ideas?
>> >> > > > > --
>> >> > > > > TIA,
>> >> > > > > ChrisR
>> >> > > >
>> >> > > >
>>|||Im going to reinstall with a more current version and see what happens.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
> the following folder structure:
> SQL Server Configuration Manager
> SQL Server 2005 Network Configuration
> Protocols for [instancename]
> In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> > And do what to the netlibs? I dont see anything like enable remote connections.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
> >> Here
> >> you can enable the netlibs.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> >> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> >> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >> >
> >> > --
> >> > TIA,
> >> > ChrisR
> >> >
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> >> Start\ Programs\ there is no Configuration Tools option.
> >> >> --
> >> >> TIA,
> >> >> ChrisR
> >> >>
> >> >>
> >> >> "burt_king" wrote:
> >> >>
> >> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> >> > Configuration tool?
> >> >> >
> >> >> > "ChrisR" wrote:
> >> >> >
> >> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> >> > > Beta2. Could this have sometihng to do with it?
> >> >> > > --
> >> >> > > TIA,
> >> >> > > ChrisR
> >> >> > >
> >> >> > >
> >> >> > > "Corey Bunch" wrote:
> >> >> > >
> >> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> >> > > >
> >> >> > > > ChrisR wrote:
> >> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> >> > > > >
> >> >> > > > > A connection was successfully established to the server, but then an error
> >> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> >> > > > > 10054)
> >> >> > > > >
> >> >> > > > > Any ideas?
> >> >> > > > > --
> >> >> > > > > TIA,
> >> >> > > > > ChrisR
> >> >> > > >
> >> >> > > >
> >>
> >>
>

cant register sql2k5

Can't register SQL Server locally due to Login problems

Hello,
I had installed SQL Server 2000 locally on my machine and I had 2 security
logins: -
1. sa - default database was set to dbTest
2. mydomain\myusername - default database was set to dbTest
The thing is, "dbTest" was deleted due to some testing and now when I try
to connect to my SQL Server with Enterprise Manager, Login fails as the
default database is missing.
Is there a way I can register back my server ?
Thanks,
Sam.
Message posted via http://www.sqlmonster.com
You can try connecting via osql.exe (a command line tool) and issue the
appropriate command to change the default database (using sp_defaultdb).
or
You can try modifying your shortcut to Query Analyzer to something like
this:
"C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\isqlw.exe" -SYourMachineNameHere -Usa -PTheSApwdGoesHer
e -dtempdb
I use the modified shortcut method to connect to a specific server and
connect to a specific database. However I don't know if you will be able to
do this if the user's default database is unavailable.
Keith
"Sameer Premji via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:3c315b71f1a74a548e1b9c93ad0da038@.SQLMonster.c om...
> Hello,
> I had installed SQL Server 2000 locally on my machine and I had 2 security
> logins: -
> 1. sa - default database was set to dbTest
> 2. mydomain\myusername - default database was set to dbTest
> The thing is, "dbTest" was deleted due to some testing and now when I try
> to connect to my SQL Server with Enterprise Manager, Login fails as the
> default database is missing.
> Is there a way I can register back my server ?
> Thanks,
> Sam.
> --
> Message posted via http://www.sqlmonster.com
|||The shortcut didn't work.
How do I use osql.exe because double-clicking on it, vanishes and what is
the statement ?
Message posted via http://www.sqlmonster.com
|||Since osql is a command line tool you need to
Start | Run | cmd <enter>
osql /? <enter>
Keith
"Sameer Premji via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:2313ae62041a424caca786036f7b4385@.SQLMonster.c om...
> The shortcut didn't work.
> How do I use osql.exe because double-clicking on it, vanishes and what is
> the statement ?
> --
> Message posted via http://www.sqlmonster.com

Can't register SQL Server locally due to Login problems

Hello,
I had installed SQL Server 2000 locally on my machine and I had 2 security
logins: -
1. sa - default database was set to dbTest
2. mydomain\myusername - default database was set to dbTest
The thing is, "dbTest" was deleted due to some testing and now when I try
to connect to my SQL Server with Enterprise Manager, Login fails as the
default database is missing.
Is there a way I can register back my server ?
Thanks,
Sam.
Message posted via http://www.droptable.comYou can try connecting via osql.exe (a command line tool) and issue the
appropriate command to change the default database (using sp_defaultdb).
or
You can try modifying your shortcut to Query Analyzer to something like
this:
"C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\isqlw.exe" -SYourMachineNameHere -Usa -PTheSApwdGoesHer
e -dtempdb
I use the modified shortcut method to connect to a specific server and
connect to a specific database. However I don't know if you will be able to
do this if the user's default database is unavailable.
Keith
"Sameer Premji via droptable.com" <forum@.droptable.com> wrote in message
news:3c315b71f1a74a548e1b9c93ad0da038@.SQ
droptable.com...
> Hello,
> I had installed SQL Server 2000 locally on my machine and I had 2 security
> logins: -
> 1. sa - default database was set to dbTest
> 2. mydomain\myusername - default database was set to dbTest
> The thing is, "dbTest" was deleted due to some testing and now when I try
> to connect to my SQL Server with Enterprise Manager, Login fails as the
> default database is missing.
> Is there a way I can register back my server ?
> Thanks,
> Sam.
> --
> Message posted via http://www.droptable.com|||The shortcut didn't work.
How do I use osql.exe because double-clicking on it, vanishes and what is
the statement ?
Message posted via http://www.droptable.com|||Since osql is a command line tool you need to
Start | Run | cmd <enter>
osql /? <enter>
Keith
"Sameer Premji via droptable.com" <forum@.droptable.com> wrote in message
news:2313ae62041a424caca786036f7b4385@.SQ
droptable.com...
> The shortcut didn't work.
> How do I use osql.exe because double-clicking on it, vanishes and what is
> the statement ?
> --
> Message posted via http://www.droptable.com

Can't register SQL Server locally due to Login problems

Hello,
I had installed SQL Server 2000 locally on my machine and I had 2 security
logins: -
1. sa - default database was set to dbTest
2. mydomain\myusername - default database was set to dbTest
The thing is, "dbTest" was deleted due to some testing and now when I try
to connect to my SQL Server with Enterprise Manager, Login fails as the
default database is missing.
Is there a way I can register back my server ?
Thanks,
Sam.
--
Message posted via http://www.sqlmonster.comYou can try connecting via osql.exe (a command line tool) and issue the
appropriate command to change the default database (using sp_defaultdb).
or
You can try modifying your shortcut to Query Analyzer to something like
this:
"C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\isqlw.exe" -SYourMachineNameHere -Usa -PTheSApwdGoesHer
e -dtempdb
I use the modified shortcut method to connect to a specific server and
connect to a specific database. However I don't know if you will be able to
do this if the user's default database is unavailable.
--
Keith
"Sameer Premji via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:3c315b71f1a74a548e1b9c93ad0da038@.SQLMonster.com...
> Hello,
> I had installed SQL Server 2000 locally on my machine and I had 2 security
> logins: -
> 1. sa - default database was set to dbTest
> 2. mydomain\myusername - default database was set to dbTest
> The thing is, "dbTest" was deleted due to some testing and now when I try
> to connect to my SQL Server with Enterprise Manager, Login fails as the
> default database is missing.
> Is there a way I can register back my server ?
> Thanks,
> Sam.
> --
> Message posted via http://www.sqlmonster.com|||The shortcut didn't work.
How do I use osql.exe because double-clicking on it, vanishes and what is
the statement ?
--
Message posted via http://www.sqlmonster.com|||Since osql is a command line tool you need to
Start | Run | cmd <enter>
osql /? <enter>
--
Keith
"Sameer Premji via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:2313ae62041a424caca786036f7b4385@.SQLMonster.com...
> The shortcut didn't work.
> How do I use osql.exe because double-clicking on it, vanishes and what is
> the statement ?
> --
> Message posted via http://www.sqlmonster.com

Can't Register SQL server in EM

I have been trying to register a SQL server in my server
group in Enterprise Manager but it cannot find the
server. The SQL server (SQLServer2k) resides on a server
machine running WinServer2K. I am trying to gain access
from a remote PC running Win2k.
I am able to see the server in the list of available
servers when I run the registration wizard. But when I
finish the wizard it fails to establish a connection. I
have double checked login ID and password. I even set up
another instance of a SQL server on the server machine.
When I start the wizard again to register the new server,
I see the new server in the available list but I can't
connect to it either.
I uninstalled and reinstalled SQLServer2k on both the
server and the client PC. Still no luck. I can establish
ethernet connection between the two machines so it doesn't
appear to be a network problem, especially when I can see
the servers in my availability list.
Any ideas on why this is happening?
Roger.
What error are you getting when the connection failure occurs?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I get a simple "Timeout expired" message. (in detail: "<servername> - Timeout expired")
Roger.
-- Rand Boyd [MSFT] wrote: --
What error are you getting when the connection failure occurs?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Try increasing the login timeout for Enterprise Manager. In
Enterprise Manager, go to the menu to tools and then select
Options. On the Advanced tab, increase the login timeout
from the default 4 seconds.
-Sue
On Fri, 7 May 2004 09:16:04 -0700, "Roger Denison"
<anonymous@.discussions.microsoft.com> wrote:

>I get a simple "Timeout expired" message. (in detail: "<servername> - Timeout expired")
>Roger.
> -- Rand Boyd [MSFT] wrote: --
> What error are you getting when the connection failure occurs?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||set the login time out to 0 which is unlimited
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:Mw9dC72MEHA.3780@.cpmsftngxa10.phx.gbl...
> What error are you getting when the connection failure occurs?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

Can't register SQL Server 2000 database with 2005 Management Studio

I was told (by a Microsoft architect) that this works, but can't find any documentation or any clues within Management Studio.

The only way I can see to register a database is to make it a "Database Engine" (whatever that is). I give it a server name and SQL Server login. Error is:

TITLE: Connect to Server

Cannot connect to <servername>.

ADDITIONAL INFORMATION:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

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

BUTTONS:

Mark,

I'm going to move this thread to the Tools General forum where I think you'll get a faster response.

-Jeffrey

|||Make sure that the server is reachable from the machine and that it is using the default port, otherwise you have to specify the different port with the syntax Servername\InstanceName,Port or for default instances Servername,Port.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Also, you should have no problems registering the server, but you might have problems connecting to it [either OE or a new QE window]. If so, like the author above noticed, you might be having problems with the port, enabled protocols etc...|||Success! Thanks Jens. I never would've guessed that syntax.

Can't Register Servers in Enterprise Managers

I posted this in the wrong forum, so if you see this in SQL Programming it was a mistake on my part.
I have two users that can't register servers in Enterprise Manager, and they're getting "login failed" when they try.
I've searched the errorlog file for any indication of the failure, but there are no entries being written. I've tried deleting and re-adding the accounts, but no luck.
Suggestions on now to fix?
Thanks,
DaleHow are they trying to authenticate...windows or SQL?
"Dale Chavez" wrote:
> I posted this in the wrong forum, so if you see this in SQL Programming it was a mistake on my part.
> I have two users that can't register servers in Enterprise Manager, and they're getting "login failed" when they try.
>
> I've searched the errorlog file for any indication of the failure, but there are no entries being written. I've tried deleting and re-adding the accounts, but no luck.
>
> Suggestions on now to fix?
>
> Thanks,
> Dale
>

Can't Register Server.

Hi : )

I have been trying to register 2 Servers in my Analysis Manager,
and have 2 different problems with them. One of them is my localhost.

When trying to connect my localhost I get this message:

Cannot connect to the repository
Analysis Server: CIN
Error[Microsoft][Administrador de controladores ODBC]El nombre del origen de datos es demasiado largo

Then, the Remote server I need to connect sends an error message like this:
Cannot connect to the repository.
Analysis Server: SVR
Error: No se pudo usar "; el archivo ya está en uso.

Would you please help me :S

Hello. I think that you are talking about AS2000.

Are you a member of the OLAP-administrators group on your localhost machine and on the remote server?

In the second case I think that this AS2000 server already have another user that have connected to AS2000 with the cube manager/editor.

These are guesses!

HTH

Thomas Ivarsson

|||

Hello Thomas,
I've verified my permissions on OLAP Administrators Group in both, my localhost and the server. The problem with my localhost happens just few days ago, I used to work fine on it but, suddenly start the error message. I have tried to unregister the server and register again but the problem persists : (

With the remote server what I have made is a trust relationship which is the way I get connected to the rest of the servers, but I do not understand the kind of error message. I have verified that no other uses have a session on it.

Thanks for your time in advance : )

|||

Hello again mayraims

I would check the following:

Difference in service packs/versions/patches between your local mmc-snapin, your local AS2000 and the remote server.|||

Thank You again Thomas,

Actually my problem to get connected in my local server was the repository Connection String

can't register server in enterprise manager

I have a SQL 2000 Server that I just recently moved into an AD domain from
an NT domain. We created new windows authentication accounts for all users
and things have worked fine except for a couple of people. Three people
can't access any databases.
On my PC, if I login as myself and go to EM I can register this server with
no problems. If I login as one of these users, I get the following when
trying to register the server:
A connection could not be established to <servername>
Reason: Login failed for user <domain>\<user>
Please verify SQL Server is running and check your SQL Server registration
properties and try again.
SQL is definitely running and it is not a password problem since I logged in
just fine to the PC. Also, the user has local Administrator access to the
PC. I don't understand why 3 out of 30 login accounts are doing this. Can
anyone help?
Thanks.Hello,
You may want to first create a new domain user and then add it as a SQL
login to test the sitaution. If the issue does not occur, it seems to be
some issue with the specific user accounts. You may want to try following
steps for a problemtic domain login.
1. Remove all SQL logins with similar name from SQL logins
2. Remove the domain user from the AD
3. Try to create a new domain user with the same name, and add it again as
a SQL login.
4. Test if the issue still occurs at this time.
If the issue perists, you may try the following steps to isolate the issue:
1. Add the following registry keys:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanmanServer\Parameters
DisableStrictNameChecking DWORD Value=1
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
DisableLoopbackCheck DWORD
Value=1
2. Edit the Local Security policy and set ?Network Security: LAN Manager
authentication level? to ?Send LM and NTLM responses?
3. Test if the issue occurs at this time.
926642 Error message when you try to access a server locally by using its
FQDN or its CNAME alias after you install Windows Server 2003 Service Pack
1: "Access denied" or "No network provider accepted the given network path"
http://support.microsoft.com/default.aspx?scid=kb;EN-US;926642
If you have any update on the issue, please feel free to let's know. Thank
you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||r
Take a look into ERROR.LOG , what is says?
When you create a login for one of those people what default database you
granted for them? Does it exist? Perhaps it is in suspect mode?
"r" <none@.none.com> wrote in message
news:uqolHls%23HHA.3900@.TK2MSFTNGP02.phx.gbl...
>I have a SQL 2000 Server that I just recently moved into an AD domain from
>an NT domain. We created new windows authentication accounts for all users
>and things have worked fine except for a couple of people. Three people
>can't access any databases.
> On my PC, if I login as myself and go to EM I can register this server
> with no problems. If I login as one of these users, I get the following
> when trying to register the server:
> A connection could not be established to <servername>
> Reason: Login failed for user <domain>\<user>
> Please verify SQL Server is running and check your SQL Server
> registration properties and try again.
> SQL is definitely running and it is not a password problem since I logged
> in just fine to the PC. Also, the user has local Administrator access to
> the PC. I don't understand why 3 out of 30 login accounts are doing this.
> Can anyone help?
> Thanks.
>

can't register server

I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
have no domain. I have two clients, one w2k Pro, sp4, and the other
XP, sp1. I'm using Windows authentication. Neither can register my
server. The error msg is the same for both:
<mysvr> - SQL Server does not exist or access denied.
ConnectionOpen (Connect())
Mind you, the server did show up in the client window, so the client
does seem to know that the server does exist.
Might anyone have an iea as to what I've done wrong? Or haven't done?
Thanks in advance,
Tom
Do you have a firewall running on the box that is hosting SQL Server?
Perhaps it is blocking the connection attempts.
Keith
"Tcs" <tsmith@.eastpointcityNoSpam.org> wrote in message
news:s5ev619fasn9sskr0pdvevu9mfarrldo3l@.4ax.com...
>I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
> have no domain. I have two clients, one w2k Pro, sp4, and the other
> XP, sp1. I'm using Windows authentication. Neither can register my
> server. The error msg is the same for both:
> <mysvr> - SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> Mind you, the server did show up in the client window, so the client
> does seem to know that the server does exist.
> Might anyone have an iea as to what I've done wrong? Or haven't done?
> Thanks in advance,
> Tom
>
|||Tom hi,
Did you check your client network utility in your clients. Is any record in
there?
You use DHCP or static IP?
Is your name resolution correct?
Are your windows logins in the SQL Server logins?
Check these first
HTH
Andreas
"Tcs" wrote:

> I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
> have no domain. I have two clients, one w2k Pro, sp4, and the other
> XP, sp1. I'm using Windows authentication. Neither can register my
> server. The error msg is the same for both:
> <mysvr> - SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> Mind you, the server did show up in the client window, so the client
> does seem to know that the server does exist.
> Might anyone have an iea as to what I've done wrong? Or haven't done?
> Thanks in advance,
> Tom
>

Thursday, March 8, 2012

cant register to server from client

Cant register to a named instance

Cant register to a named instance

Wednesday, March 7, 2012

Cant register to a named instance

Can't register SSIS server in SMS...need permissions help.

Can't Register SQLServer in Enterprise Manager

Can't Register SQLServer in Enterprise Manager

Can't register SQL-DMO

cant register sql2k5

cant register sql2k5

cant register sql2k5

Can't register SQL Server locally due to Login problems

Can't register SQL Server locally due to Login problems

Can't register SQL Server locally due to Login problems

Can't Register SQL server in EM

Can't register SQL Server 2000 database with 2005 Management Studio

Can't Register Servers in Enterprise Managers

Can't Register Server.

can't register server in enterprise manager

can't register server

sql report manager

Blog Archive

About Me