hi,
i am new to SQL Server 2000 n trying to set up a Server in Windows 200
pro,
but whenever i try to Register the server it fails n gives the below
error,
ConnectionOpen(Connect()) faIled.
plz if some one can rectify this issue,
thanks in advance,
mandeepFirstly check if your SQL Server services are running; If yes then
proceed
Start-->programs --> Microsoft SQL Server --> Client Network Utility
Check to see if TCP/IP and NamedPipes are enabled only check if Shared
Memory is checked, if its not checked, check it
Showing posts with label register. Show all posts
Showing posts with label register. Show all posts
Monday, March 19, 2012
Connectiong to SQL Server 2000 over VPN
Hi, hoping someone can help me out here. I am opening enterprise manager and trying to register a new server for which I have permissions. When I use windows authentication I get "Login Failed for user "(null)" and when I use SQL Server Authentication I get "Login failed for user "sa".
I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?
Thanks in advance.Can you reach the server on the VPN (ping it) ?
if not, you need to reconfigurate your network settings(IP of the switch connectiong to the VPN)
if you can ping it, you should have no problem using SQL server Authentication (unless firewall filter the SQL Server port)
Originally posted by kevin86
Hi, hoping someone can help me out here. I am opening enterprise manager and trying to register a new server for which I have permissions. When I use windows authentication I get "Login Failed for user "(null)" and when I use SQL Server Authentication I get "Login failed for user "sa".
I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?
Thanks in advance.|||I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.
How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||I think you have to ask to the system admin for the firewall.
Do you asked someone on the domain (not using the VPN) to try login SQL server with the same users you tried ?
Originally posted by kevin86
I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.
How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||Someone on the domain was able to log in using the id's I tried.
I just spoke to our network admin and these ports are not blocked. Any other suggestions?|||Originally posted by kevin86
Someone on the domain was able to log in using the id's I tried.
I just spoke to our network admin and these ports are not blocked. Any other suggestions?
You cannot register as windows nt user (trusted) cos you might not be added to that server as a user, and as you are able to ping the server , you are suppose to register the server using sql login, the only reason i would say you are not able to register is the sa password is wrong, try overwriting the password froom any of the machines where its already connected and then register it ...you should be able to connect ...
I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?
Thanks in advance.Can you reach the server on the VPN (ping it) ?
if not, you need to reconfigurate your network settings(IP of the switch connectiong to the VPN)
if you can ping it, you should have no problem using SQL server Authentication (unless firewall filter the SQL Server port)
Originally posted by kevin86
Hi, hoping someone can help me out here. I am opening enterprise manager and trying to register a new server for which I have permissions. When I use windows authentication I get "Login Failed for user "(null)" and when I use SQL Server Authentication I get "Login failed for user "sa".
I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?
Thanks in advance.|||I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.
How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||I think you have to ask to the system admin for the firewall.
Do you asked someone on the domain (not using the VPN) to try login SQL server with the same users you tried ?
Originally posted by kevin86
I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.
How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||Someone on the domain was able to log in using the id's I tried.
I just spoke to our network admin and these ports are not blocked. Any other suggestions?|||Originally posted by kevin86
Someone on the domain was able to log in using the id's I tried.
I just spoke to our network admin and these ports are not blocked. Any other suggestions?
You cannot register as windows nt user (trusted) cos you might not be added to that server as a user, and as you are able to ping the server , you are suppose to register the server using sql login, the only reason i would say you are not able to register is the sa password is wrong, try overwriting the password froom any of the machines where its already connected and then register it ...you should be able to connect ...
Thursday, March 8, 2012
Connection to SQL Server 2000 From an ASP Page
Dear All,
I'm really confusing while reading the connections Issue in the support
knowledge.
Our Company website guest users can register themselves in my website. The
data goes to the SQL Server database 2000 which also used by internal users
of my company as Inhouse Database. So I want to restrict the Website Guest
users. Whats the safest way to connect to?.
Actually MY IIS SQL Server running on different machine(as stated in
support base)
1. I have created windows user a/c (say WEBUSER) on both machines with the
same password.
2. I have created a login a/c SQL Server for WEBUSER too.
But unfortunately I am getting "Internal Server Error" - Page Can not be
Displayed.
My connection String is as follows:
dc0.Open "Provider=sqloledb;" & _
"Network Library=DBNETLIB;" & _
"Integrated Security=SSPI." & _
"Data Source=ServerName;" & _
"Initial Catalog=DatabaseName;" & _
"User ID=UserName;" & _
"Password=password"
Please advice me is this safe?. Why I'm getting the error?
Thanks
Kavi
As a first step, try the following:
Log onto SQL Query Analyser and log on with the DataSource/username/password
that is used withing your connection string.
If this is OK , simulate a SQL statement that is similar that will run by a
web user.
At this point, you'll know that the account is OK.
can you connect , for example, via telnet to the sql server?
Are other pages running on the web server.
Also, see if you can trap the error and print it on the page.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
news:FA375A40-B27B-44DE-9584-7CC8B781AFE1@.microsoft.com...
> Dear All,
> I'm really confusing while reading the connections Issue in the support
> knowledge.
> Our Company website guest users can register themselves in my website. The
> data goes to the SQL Server database 2000 which also used by internal
users
> of my company as Inhouse Database. So I want to restrict the Website Guest
> users. Whats the safest way to connect to?.
> Actually MY IIS SQL Server running on different machine(as stated in
> support base)
> 1. I have created windows user a/c (say WEBUSER) on both machines with
the
> same password.
> 2. I have created a login a/c SQL Server for WEBUSER too.
> But unfortunately I am getting "Internal Server Error" - Page Can not be
> Displayed.
> My connection String is as follows:
> dc0.Open "Provider=sqloledb;" & _
> "Network Library=DBNETLIB;" & _
> "Integrated Security=SSPI." & _
> "Data Source=ServerName;" & _
> "Initial Catalog=DatabaseName;" & _
> "User ID=UserName;" & _
> "Password=password"
> Please advice me is this safe?. Why I'm getting the error?
> Thanks
> Kavi
>
|||Thanks Jack. I'll try.
"Jack Vamvas" wrote:
> As a first step, try the following:
> Log onto SQL Query Analyser and log on with the DataSource/username/password
> that is used withing your connection string.
> If this is OK , simulate a SQL statement that is similar that will run by a
> web user.
> At this point, you'll know that the account is OK.
> can you connect , for example, via telnet to the sql server?
> Are other pages running on the web server.
> Also, see if you can trap the error and print it on the page.
>
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
>
> "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> news:FA375A40-B27B-44DE-9584-7CC8B781AFE1@.microsoft.com...
> users
> the
>
>
|||In the Advanced tab of Internet Options of IE, uncheck "Show friendly
HTTP error messages". Then you usually can see the whole error
message.
Shane
I'm really confusing while reading the connections Issue in the support
knowledge.
Our Company website guest users can register themselves in my website. The
data goes to the SQL Server database 2000 which also used by internal users
of my company as Inhouse Database. So I want to restrict the Website Guest
users. Whats the safest way to connect to?.
Actually MY IIS SQL Server running on different machine(as stated in
support base)
1. I have created windows user a/c (say WEBUSER) on both machines with the
same password.
2. I have created a login a/c SQL Server for WEBUSER too.
But unfortunately I am getting "Internal Server Error" - Page Can not be
Displayed.
My connection String is as follows:
dc0.Open "Provider=sqloledb;" & _
"Network Library=DBNETLIB;" & _
"Integrated Security=SSPI." & _
"Data Source=ServerName;" & _
"Initial Catalog=DatabaseName;" & _
"User ID=UserName;" & _
"Password=password"
Please advice me is this safe?. Why I'm getting the error?
Thanks
Kavi
As a first step, try the following:
Log onto SQL Query Analyser and log on with the DataSource/username/password
that is used withing your connection string.
If this is OK , simulate a SQL statement that is similar that will run by a
web user.
At this point, you'll know that the account is OK.
can you connect , for example, via telnet to the sql server?
Are other pages running on the web server.
Also, see if you can trap the error and print it on the page.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
news:FA375A40-B27B-44DE-9584-7CC8B781AFE1@.microsoft.com...
> Dear All,
> I'm really confusing while reading the connections Issue in the support
> knowledge.
> Our Company website guest users can register themselves in my website. The
> data goes to the SQL Server database 2000 which also used by internal
users
> of my company as Inhouse Database. So I want to restrict the Website Guest
> users. Whats the safest way to connect to?.
> Actually MY IIS SQL Server running on different machine(as stated in
> support base)
> 1. I have created windows user a/c (say WEBUSER) on both machines with
the
> same password.
> 2. I have created a login a/c SQL Server for WEBUSER too.
> But unfortunately I am getting "Internal Server Error" - Page Can not be
> Displayed.
> My connection String is as follows:
> dc0.Open "Provider=sqloledb;" & _
> "Network Library=DBNETLIB;" & _
> "Integrated Security=SSPI." & _
> "Data Source=ServerName;" & _
> "Initial Catalog=DatabaseName;" & _
> "User ID=UserName;" & _
> "Password=password"
> Please advice me is this safe?. Why I'm getting the error?
> Thanks
> Kavi
>
|||Thanks Jack. I'll try.
"Jack Vamvas" wrote:
> As a first step, try the following:
> Log onto SQL Query Analyser and log on with the DataSource/username/password
> that is used withing your connection string.
> If this is OK , simulate a SQL statement that is similar that will run by a
> web user.
> At this point, you'll know that the account is OK.
> can you connect , for example, via telnet to the sql server?
> Are other pages running on the web server.
> Also, see if you can trap the error and print it on the page.
>
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
>
> "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> news:FA375A40-B27B-44DE-9584-7CC8B781AFE1@.microsoft.com...
> users
> the
>
>
|||In the Advanced tab of Internet Options of IE, uncheck "Show friendly
HTTP error messages". Then you usually can see the whole error
message.
Shane
Connection to SQL Server 2000 From an ASP Page
Dear All,
I'm really confusing while reading the connections Issue in the support
knowledge.
Our Company website guest users can register themselves in my website. The
data goes to the SQL Server database 2000 which also used by internal users
of my company as Inhouse Database. So I want to restrict the Website Guest
users. Whats the safest way to connect to?.
Actually MY IIS SQL Server running on different machine(as stated in
support base)
1. I have created windows user a/c (say WEBUSER) on both machines with the
same password.
2. I have created a login a/c SQL Server for WEBUSER too.
But unfortunately I am getting "Internal Server Error" - Page Can not be
Displayed.
My connection String is as follows:
dc0.Open "Provider=sqloledb;" & _
"Network Library=DBNETLIB;" & _
"Integrated Security=SSPI." & _
"Data Source=ServerName;" & _
"Initial Catalog=DatabaseName;" & _
"User ID=UserName;" & _
"Password=password"
Please advice me is this safe?. Why I'm getting the error?
Thanks
KaviAs a first step, try the following:
Log onto SQL Query Analyser and log on with the DataSource/username/password
that is used withing your connection string.
If this is OK , simulate a SQL statement that is similar that will run by a
web user.
At this point, you'll know that the account is OK.
can you connect , for example, via telnet to the sql server?
Are other pages running on the web server.
Also, see if you can trap the error and print it on the page.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
news:FA375A40-B27B-44DE-9584-7CC8B781AFE1@.microsoft.com...
> Dear All,
> I'm really confusing while reading the connections Issue in the support
> knowledge.
> Our Company website guest users can register themselves in my website. The
> data goes to the SQL Server database 2000 which also used by internal
users
> of my company as Inhouse Database. So I want to restrict the Website Guest
> users. Whats the safest way to connect to?.
> Actually MY IIS SQL Server running on different machine(as stated in
> support base)
> 1. I have created windows user a/c (say WEBUSER) on both machines with
the
> same password.
> 2. I have created a login a/c SQL Server for WEBUSER too.
> But unfortunately I am getting "Internal Server Error" - Page Can not be
> Displayed.
> My connection String is as follows:
> dc0.Open "Provider=sqloledb;" & _
> "Network Library=DBNETLIB;" & _
> "Integrated Security=SSPI." & _
> "Data Source=ServerName;" & _
> "Initial Catalog=DatabaseName;" & _
> "User ID=UserName;" & _
> "Password=password"
> Please advice me is this safe?. Why I'm getting the error?
> Thanks
> Kavi
>|||Thanks Jack. I'll try.
"Jack Vamvas" wrote:
> As a first step, try the following:
> Log onto SQL Query Analyser and log on with the DataSource/username/passwo
rd
> that is used withing your connection string.
> If this is OK , simulate a SQL statement that is similar that will run by
a
> web user.
> At this point, you'll know that the account is OK.
> can you connect , for example, via telnet to the sql server?
> Are other pages running on the web server.
> Also, see if you can trap the error and print it on the page.
>
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
>
> "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> news:FA375A40-B27B-44DE-9584-7CC8B781AFE1@.microsoft.com...
> users
> the
>
>|||In the Advanced tab of Internet Options of IE, uncheck "Show friendly
HTTP error messages". Then you usually can see the whole error
message.
Shane
I'm really confusing while reading the connections Issue in the support
knowledge.
Our Company website guest users can register themselves in my website. The
data goes to the SQL Server database 2000 which also used by internal users
of my company as Inhouse Database. So I want to restrict the Website Guest
users. Whats the safest way to connect to?.
Actually MY IIS SQL Server running on different machine(as stated in
support base)
1. I have created windows user a/c (say WEBUSER) on both machines with the
same password.
2. I have created a login a/c SQL Server for WEBUSER too.
But unfortunately I am getting "Internal Server Error" - Page Can not be
Displayed.
My connection String is as follows:
dc0.Open "Provider=sqloledb;" & _
"Network Library=DBNETLIB;" & _
"Integrated Security=SSPI." & _
"Data Source=ServerName;" & _
"Initial Catalog=DatabaseName;" & _
"User ID=UserName;" & _
"Password=password"
Please advice me is this safe?. Why I'm getting the error?
Thanks
KaviAs a first step, try the following:
Log onto SQL Query Analyser and log on with the DataSource/username/password
that is used withing your connection string.
If this is OK , simulate a SQL statement that is similar that will run by a
web user.
At this point, you'll know that the account is OK.
can you connect , for example, via telnet to the sql server?
Are other pages running on the web server.
Also, see if you can trap the error and print it on the page.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
news:FA375A40-B27B-44DE-9584-7CC8B781AFE1@.microsoft.com...
> Dear All,
> I'm really confusing while reading the connections Issue in the support
> knowledge.
> Our Company website guest users can register themselves in my website. The
> data goes to the SQL Server database 2000 which also used by internal
users
> of my company as Inhouse Database. So I want to restrict the Website Guest
> users. Whats the safest way to connect to?.
> Actually MY IIS SQL Server running on different machine(as stated in
> support base)
> 1. I have created windows user a/c (say WEBUSER) on both machines with
the
> same password.
> 2. I have created a login a/c SQL Server for WEBUSER too.
> But unfortunately I am getting "Internal Server Error" - Page Can not be
> Displayed.
> My connection String is as follows:
> dc0.Open "Provider=sqloledb;" & _
> "Network Library=DBNETLIB;" & _
> "Integrated Security=SSPI." & _
> "Data Source=ServerName;" & _
> "Initial Catalog=DatabaseName;" & _
> "User ID=UserName;" & _
> "Password=password"
> Please advice me is this safe?. Why I'm getting the error?
> Thanks
> Kavi
>|||Thanks Jack. I'll try.
"Jack Vamvas" wrote:
> As a first step, try the following:
> Log onto SQL Query Analyser and log on with the DataSource/username/passwo
rd
> that is used withing your connection string.
> If this is OK , simulate a SQL statement that is similar that will run by
a
> web user.
> At this point, you'll know that the account is OK.
> can you connect , for example, via telnet to the sql server?
> Are other pages running on the web server.
> Also, see if you can trap the error and print it on the page.
>
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
>
> "Kavi" <Kavi@.discussions.microsoft.com> wrote in message
> news:FA375A40-B27B-44DE-9584-7CC8B781AFE1@.microsoft.com...
> users
> the
>
>|||In the Advanced tab of Internet Options of IE, uncheck "Show friendly
HTTP error messages". Then you usually can see the whole error
message.
Shane
Connection to Server Failed - Analysis Services
Hi,
For some unknown reason, we are getting the following "Connection to Server
Failed" error message when we attempt to register our local server using MS
Analysis Services:
"Errors occurred while connecting to '<localservername>'. Cannot open
connection to Analysis server '<localservername>'. Cannot connect to the
server '<localservername>'. The server is either not started or too busy. Do
you still want to register the server?
Please note that we are running the Developer versions of MS SQL Server 2000
and MS Analysis Services with SP3 installed for both components on Windows X
P
Professional.
Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
Analysis Manager, but we aren't able to either register or connect to a loca
l
server because we get the message above.
We are uttterly confused by this error message and would GREATLY APPRECIATE
any help in resolving this confusing issue as soon as possible.
Thanks,
Raj C.Is the Analysis services service started on the local machine?
Simon Worth
Raj C. wrote:
> Hi,
> For some unknown reason, we are getting the following "Connection to Serve
r
> Failed" error message when we attempt to register our local server using M
S
> Analysis Services:
> "Errors occurred while connecting to '<localservername>'. Cannot open
> connection to Analysis server '<localservername>'. Cannot connect to the
> server '<localservername>'. The server is either not started or too busy.
Do
> you still want to register the server?
> Please note that we are running the Developer versions of MS SQL Server 20
00
> and MS Analysis Services with SP3 installed for both components on Windows
XP
> Professional.
> Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
> Analysis Manager, but we aren't able to either register or connect to a lo
cal
> server because we get the message above.
> We are uttterly confused by this error message and would GREATLY APPRECIAT
E
> any help in resolving this confusing issue as soon as possible.
> Thanks,
> Raj C.|||If you mean did we launch Analysis Manager on the local machine - than yes.
But for some unknown reason, we can't register the local server but we can
register a remote server on the network. FYI - Our login name is a member o
f
the OLAP admin group.
Please HELP!
Raj C.
"Simon Worth" wrote:
> Is the Analysis services service started on the local machine?
> Simon Worth
> Raj C. wrote:
>|||No, I mean, is the actual Analysis Services Service running on the machine?
To start Microsoft? SQL Server? 2000 Analysis Services, follow these step
s:
Open Control Panel.
If your computer's operating system is Windows? 2000, open the
Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT? 4.0, double-click
Services.
Select MSSQLServerOLAPService, and then on the Action menu click Start.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> If you mean did we launch Analysis Manager on the local machine - than yes
.
> But for some unknown reason, we can't register the local server but we can
> register a remote server on the network. FYI - Our login name is a member
of
> the OLAP admin group.
> Please HELP!
> Raj C.
> "Simon Worth" wrote:
>|||Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
the local machine.
"Simon Worth" wrote:
> No, I mean, is the actual Analysis Services Service running on the machine
?
> To start Microsoft? SQL Server? 2000 Analysis Services, follow these st
eps:
> Open Control Panel.
>
> If your computer's operating system is Windows? 2000, open the
> Administrative Tools folder, and then double-click Services.
> If your computer's operating system is Windows NT? 4.0, double-click
> Services.
> Select MSSQLServerOLAPService, and then on the Action menu click Start.
>
>
> Simon Worth
> Raj C. wrote:
>|||But is the service started? When you view the service in control panel
> services, is the MSSQLServerOLAPService service in a started state?
You can have it installed on the machine, but it doesn't do anything if
you don't actually start the service.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services o
n
> the local machine.
>
> "Simon Worth" wrote:
>
For some unknown reason, we are getting the following "Connection to Server
Failed" error message when we attempt to register our local server using MS
Analysis Services:
"Errors occurred while connecting to '<localservername>'. Cannot open
connection to Analysis server '<localservername>'. Cannot connect to the
server '<localservername>'. The server is either not started or too busy. Do
you still want to register the server?
Please note that we are running the Developer versions of MS SQL Server 2000
and MS Analysis Services with SP3 installed for both components on Windows X
P
Professional.
Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
Analysis Manager, but we aren't able to either register or connect to a loca
l
server because we get the message above.
We are uttterly confused by this error message and would GREATLY APPRECIATE
any help in resolving this confusing issue as soon as possible.
Thanks,
Raj C.Is the Analysis services service started on the local machine?
Simon Worth
Raj C. wrote:
> Hi,
> For some unknown reason, we are getting the following "Connection to Serve
r
> Failed" error message when we attempt to register our local server using M
S
> Analysis Services:
> "Errors occurred while connecting to '<localservername>'. Cannot open
> connection to Analysis server '<localservername>'. Cannot connect to the
> server '<localservername>'. The server is either not started or too busy.
Do
> you still want to register the server?
> Please note that we are running the Developer versions of MS SQL Server 20
00
> and MS Analysis Services with SP3 installed for both components on Windows
XP
> Professional.
> Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
> Analysis Manager, but we aren't able to either register or connect to a lo
cal
> server because we get the message above.
> We are uttterly confused by this error message and would GREATLY APPRECIAT
E
> any help in resolving this confusing issue as soon as possible.
> Thanks,
> Raj C.|||If you mean did we launch Analysis Manager on the local machine - than yes.
But for some unknown reason, we can't register the local server but we can
register a remote server on the network. FYI - Our login name is a member o
f
the OLAP admin group.
Please HELP!
Raj C.
"Simon Worth" wrote:
> Is the Analysis services service started on the local machine?
> Simon Worth
> Raj C. wrote:
>|||No, I mean, is the actual Analysis Services Service running on the machine?
To start Microsoft? SQL Server? 2000 Analysis Services, follow these step
s:
Open Control Panel.
If your computer's operating system is Windows? 2000, open the
Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT? 4.0, double-click
Services.
Select MSSQLServerOLAPService, and then on the Action menu click Start.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> If you mean did we launch Analysis Manager on the local machine - than yes
.
> But for some unknown reason, we can't register the local server but we can
> register a remote server on the network. FYI - Our login name is a member
of
> the OLAP admin group.
> Please HELP!
> Raj C.
> "Simon Worth" wrote:
>|||Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
the local machine.
"Simon Worth" wrote:
> No, I mean, is the actual Analysis Services Service running on the machine
?
> To start Microsoft? SQL Server? 2000 Analysis Services, follow these st
eps:
> Open Control Panel.
>
> If your computer's operating system is Windows? 2000, open the
> Administrative Tools folder, and then double-click Services.
> If your computer's operating system is Windows NT? 4.0, double-click
> Services.
> Select MSSQLServerOLAPService, and then on the Action menu click Start.
>
>
> Simon Worth
> Raj C. wrote:
>|||But is the service started? When you view the service in control panel
> services, is the MSSQLServerOLAPService service in a started state?
You can have it installed on the machine, but it doesn't do anything if
you don't actually start the service.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services o
n
> the local machine.
>
> "Simon Worth" wrote:
>
Connection to Server Failed - Analysis Services
Hi,
For some unknown reason, we are getting the following "Connection to Server
Failed" error message when we attempt to register our local server using MS
Analysis Services:
"Errors occurred while connecting to '<localservername>'. Cannot open
connection to Analysis server '<localservername>'. Cannot connect to the
server '<localservername>'. The server is either not started or too busy. Do
you still want to register the server?
Please note that we are running the Developer versions of MS SQL Server 2000
and MS Analysis Services with SP3 installed for both components on Windows XP
Professional.
Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
Analysis Manager, but we aren't able to either register or connect to a local
server because we get the message above.
We are uttterly confused by this error message and would GREATLY APPRECIATE
any help in resolving this confusing issue as soon as possible.
Thanks,
Raj C.
Is the Analysis services service started on the local machine?
Simon Worth
Raj C. wrote:
> Hi,
> For some unknown reason, we are getting the following "Connection to Server
> Failed" error message when we attempt to register our local server using MS
> Analysis Services:
> "Errors occurred while connecting to '<localservername>'. Cannot open
> connection to Analysis server '<localservername>'. Cannot connect to the
> server '<localservername>'. The server is either not started or too busy. Do
> you still want to register the server?
> Please note that we are running the Developer versions of MS SQL Server 2000
> and MS Analysis Services with SP3 installed for both components on Windows XP
> Professional.
> Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
> Analysis Manager, but we aren't able to either register or connect to a local
> server because we get the message above.
> We are uttterly confused by this error message and would GREATLY APPRECIATE
> any help in resolving this confusing issue as soon as possible.
> Thanks,
> Raj C.
|||If you mean did we launch Analysis Manager on the local machine - than yes.
But for some unknown reason, we can't register the local server but we can
register a remote server on the network. FYI - Our login name is a member of
the OLAP admin group.
Please HELP!
Raj C.
"Simon Worth" wrote:
> Is the Analysis services service started on the local machine?
> Simon Worth
> Raj C. wrote:
>
|||No, I mean, is the actual Analysis Services Service running on the machine?
To start Microsoft? SQL Server? 2000 Analysis Services, follow these steps:
Open Control Panel.
If your computer's operating system is Windows? 2000, open the
Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT? 4.0, double-click
Services.
Select MSSQLServerOLAPService, and then on the Action menu click Start.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> If you mean did we launch Analysis Manager on the local machine - than yes.
> But for some unknown reason, we can't register the local server but we can
> register a remote server on the network. FYI - Our login name is a member of
> the OLAP admin group.
> Please HELP!
> Raj C.
> "Simon Worth" wrote:
>
|||Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
the local machine.
"Simon Worth" wrote:
> No, I mean, is the actual Analysis Services Service running on the machine?
> To start Microsoft? SQL Server? 2000 Analysis Services, follow these steps:
> Open Control Panel.
>
> If your computer's operating system is Windows? 2000, open the
> Administrative Tools folder, and then double-click Services.
> If your computer's operating system is Windows NT? 4.0, double-click
> Services.
> Select MSSQLServerOLAPService, and then on the Action menu click Start.
>
>
> Simon Worth
> Raj C. wrote:
>
|||But is the service started? When you view the service in control panel
> services, is the MSSQLServerOLAPService service in a started state?
You can have it installed on the machine, but it doesn't do anything if
you don't actually start the service.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
> the local machine.
>
> "Simon Worth" wrote:
>
For some unknown reason, we are getting the following "Connection to Server
Failed" error message when we attempt to register our local server using MS
Analysis Services:
"Errors occurred while connecting to '<localservername>'. Cannot open
connection to Analysis server '<localservername>'. Cannot connect to the
server '<localservername>'. The server is either not started or too busy. Do
you still want to register the server?
Please note that we are running the Developer versions of MS SQL Server 2000
and MS Analysis Services with SP3 installed for both components on Windows XP
Professional.
Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
Analysis Manager, but we aren't able to either register or connect to a local
server because we get the message above.
We are uttterly confused by this error message and would GREATLY APPRECIATE
any help in resolving this confusing issue as soon as possible.
Thanks,
Raj C.
Is the Analysis services service started on the local machine?
Simon Worth
Raj C. wrote:
> Hi,
> For some unknown reason, we are getting the following "Connection to Server
> Failed" error message when we attempt to register our local server using MS
> Analysis Services:
> "Errors occurred while connecting to '<localservername>'. Cannot open
> connection to Analysis server '<localservername>'. Cannot connect to the
> server '<localservername>'. The server is either not started or too busy. Do
> you still want to register the server?
> Please note that we are running the Developer versions of MS SQL Server 2000
> and MS Analysis Services with SP3 installed for both components on Windows XP
> Professional.
> Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
> Analysis Manager, but we aren't able to either register or connect to a local
> server because we get the message above.
> We are uttterly confused by this error message and would GREATLY APPRECIATE
> any help in resolving this confusing issue as soon as possible.
> Thanks,
> Raj C.
|||If you mean did we launch Analysis Manager on the local machine - than yes.
But for some unknown reason, we can't register the local server but we can
register a remote server on the network. FYI - Our login name is a member of
the OLAP admin group.
Please HELP!
Raj C.
"Simon Worth" wrote:
> Is the Analysis services service started on the local machine?
> Simon Worth
> Raj C. wrote:
>
|||No, I mean, is the actual Analysis Services Service running on the machine?
To start Microsoft? SQL Server? 2000 Analysis Services, follow these steps:
Open Control Panel.
If your computer's operating system is Windows? 2000, open the
Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT? 4.0, double-click
Services.
Select MSSQLServerOLAPService, and then on the Action menu click Start.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> If you mean did we launch Analysis Manager on the local machine - than yes.
> But for some unknown reason, we can't register the local server but we can
> register a remote server on the network. FYI - Our login name is a member of
> the OLAP admin group.
> Please HELP!
> Raj C.
> "Simon Worth" wrote:
>
|||Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
the local machine.
"Simon Worth" wrote:
> No, I mean, is the actual Analysis Services Service running on the machine?
> To start Microsoft? SQL Server? 2000 Analysis Services, follow these steps:
> Open Control Panel.
>
> If your computer's operating system is Windows? 2000, open the
> Administrative Tools folder, and then double-click Services.
> If your computer's operating system is Windows NT? 4.0, double-click
> Services.
> Select MSSQLServerOLAPService, and then on the Action menu click Start.
>
>
> Simon Worth
> Raj C. wrote:
>
|||But is the service started? When you view the service in control panel
> services, is the MSSQLServerOLAPService service in a started state?
You can have it installed on the machine, but it doesn't do anything if
you don't actually start the service.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
> the local machine.
>
> "Simon Worth" wrote:
>
Connection to MSDE fails
I'm troubleshooting a connection to an MSDE install. I tried to register
the MSDE install on the server's EM. The register server wizard shows the
laptop's MSDE install but it refuses to connect.
-No software firewall is running on the laptop
-I added TCP/IP using port 1433 to the MSDE install
-The MSDE server shows up when I browse for SQL servers on the network
-I've tried integrated security and SQL authentication but neither work.
-I can connect to the MSDE install from the laptop using both authentication
types
Any ideas why EM can browse the MSDE server but not connect?
I'm using MSDE 2000 sp3 and SQL Server 2000 sp3
ThanksIf you come up with an answer, I would appreciate notice. I am having
the same problem.
If I connect an .adp directly it is fine. Query Analyzer is fine.
I cannot connect to either remote SQL Server DB I have. It is very
frustrating.
Thank you. Sorry I can't help you either.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Check the SQL Errorlogs for the MSDE instance. See what protocols it's
listening on.
You should see Shared Memory, Named Pipes and TCP.
Also, the default security is Windows Authentication.
Next try connecting using either ISQL.exe or a Test ODBC DSN. You need the
OS error to tshoot the problem.
Example:
OS Error 53 == Network Name not found. (Named Pipe connection without
Netbios Name Resolution)
OS Error 10060 == TCP Connection Timeout
OS Error 10061 == TCP connection Refused. Possibly the client is
connecting on the wrong socket. Or the server isn't listening on tcp.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
the MSDE install on the server's EM. The register server wizard shows the
laptop's MSDE install but it refuses to connect.
-No software firewall is running on the laptop
-I added TCP/IP using port 1433 to the MSDE install
-The MSDE server shows up when I browse for SQL servers on the network
-I've tried integrated security and SQL authentication but neither work.
-I can connect to the MSDE install from the laptop using both authentication
types
Any ideas why EM can browse the MSDE server but not connect?
I'm using MSDE 2000 sp3 and SQL Server 2000 sp3
ThanksIf you come up with an answer, I would appreciate notice. I am having
the same problem.
If I connect an .adp directly it is fine. Query Analyzer is fine.
I cannot connect to either remote SQL Server DB I have. It is very
frustrating.
Thank you. Sorry I can't help you either.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Check the SQL Errorlogs for the MSDE instance. See what protocols it's
listening on.
You should see Shared Memory, Named Pipes and TCP.
Also, the default security is Windows Authentication.
Next try connecting using either ISQL.exe or a Test ODBC DSN. You need the
OS error to tshoot the problem.
Example:
OS Error 53 == Network Name not found. (Named Pipe connection without
Netbios Name Resolution)
OS Error 10060 == TCP Connection Timeout
OS Error 10061 == TCP connection Refused. Possibly the client is
connecting on the wrong socket. Or the server isn't listening on tcp.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Connection to MSDE fails
I'm troubleshooting a connection to an MSDE install. I tried to register
the MSDE install on the server's EM. The register server wizard shows the
laptop's MSDE install but it refuses to connect.
-No software firewall is running on the laptop
-I added TCP/IP using port 1433 to the MSDE install
-The MSDE server shows up when I browse for SQL servers on the network
-I've tried integrated security and SQL authentication but neither work.
-I can connect to the MSDE install from the laptop using both authentication
types
Any ideas why EM can browse the MSDE server but not connect?
I'm using MSDE 2000 sp3 and SQL Server 2000 sp3
Thanks
If you come up with an answer, I would appreciate notice. I am having
the same problem.
If I connect an .adp directly it is fine. Query Analyzer is fine.
I cannot connect to either remote SQL Server DB I have. It is very
frustrating.
Thank you. Sorry I can't help you either.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Check the SQL Errorlogs for the MSDE instance. See what protocols it's
listening on.
You should see Shared Memory, Named Pipes and TCP.
Also, the default security is Windows Authentication.
Next try connecting using either ISQL.exe or a Test ODBC DSN. You need the
OS error to tshoot the problem.
Example:
OS Error 53 == Network Name not found. (Named Pipe connection without
Netbios Name Resolution)
OS Error 10060 == TCP Connection Timeout
OS Error 10061 == TCP connection Refused. Possibly the client is
connecting on the wrong socket. Or the server isn't listening on tcp.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
the MSDE install on the server's EM. The register server wizard shows the
laptop's MSDE install but it refuses to connect.
-No software firewall is running on the laptop
-I added TCP/IP using port 1433 to the MSDE install
-The MSDE server shows up when I browse for SQL servers on the network
-I've tried integrated security and SQL authentication but neither work.
-I can connect to the MSDE install from the laptop using both authentication
types
Any ideas why EM can browse the MSDE server but not connect?
I'm using MSDE 2000 sp3 and SQL Server 2000 sp3
Thanks
If you come up with an answer, I would appreciate notice. I am having
the same problem.
If I connect an .adp directly it is fine. Query Analyzer is fine.
I cannot connect to either remote SQL Server DB I have. It is very
frustrating.
Thank you. Sorry I can't help you either.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Check the SQL Errorlogs for the MSDE instance. See what protocols it's
listening on.
You should see Shared Memory, Named Pipes and TCP.
Also, the default security is Windows Authentication.
Next try connecting using either ISQL.exe or a Test ODBC DSN. You need the
OS error to tshoot the problem.
Example:
OS Error 53 == Network Name not found. (Named Pipe connection without
Netbios Name Resolution)
OS Error 10060 == TCP Connection Timeout
OS Error 10061 == TCP connection Refused. Possibly the client is
connecting on the wrong socket. Or the server isn't listening on tcp.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Friday, February 10, 2012
Connection problem when registering a remote SQL2000
Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
Any idea ?
If you can you use Enterprise Manager from the W2003 server, please check
the following:
Launch the Properties dialog from the server object of Enterprise Manager
Select the Network Configuration button on the General tab
Is TCP/IP enabled?
Select the Connections tab
Is the Query time-out value set too low?
Is the maximum concurrent user connections value set too low?
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
Keith Wilson
"Charles" <ccolell@.softeng.es> wrote in message
news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> Hello,
> I try to register a remote SQL Server 2000 installed in a W2003, but it
> doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
> In that network , port 1433 is open and what it really surpises me, is
that
> I can connect via ODBC to any database of that remote SQL Server2000 !!!
> Any idea ?
>
|||Hello,
Yes , everything is ok. TCP/IP is enabled, and the rest values, the query
time is 600 (the default value), and the maximum users is (0, the default
value which means that are unlimited).
Any other idea ?
"Keith Wilson" <keithwi@.online.microsoft.com> escribi en el mensaje
news:4074336d$1@.news.microsoft.com...
> If you can you use Enterprise Manager from the W2003 server, please check
> the following:
> Launch the Properties dialog from the server object of Enterprise
Manager
> Select the Network Configuration button on the General tab
> Is TCP/IP enabled?
> Select the Connections tab
> Is the Query time-out value set too low?
> Is the maximum concurrent user connections value set too low?
>
> This posting is provided "AS IS" without express or implied warranty,
> guarantee, or rights.
> Keith Wilson
>
> "Charles" <ccolell@.softeng.es> wrote in message
> news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> that
>
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
Any idea ?
If you can you use Enterprise Manager from the W2003 server, please check
the following:
Launch the Properties dialog from the server object of Enterprise Manager
Select the Network Configuration button on the General tab
Is TCP/IP enabled?
Select the Connections tab
Is the Query time-out value set too low?
Is the maximum concurrent user connections value set too low?
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
Keith Wilson
"Charles" <ccolell@.softeng.es> wrote in message
news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> Hello,
> I try to register a remote SQL Server 2000 installed in a W2003, but it
> doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
> In that network , port 1433 is open and what it really surpises me, is
that
> I can connect via ODBC to any database of that remote SQL Server2000 !!!
> Any idea ?
>
|||Hello,
Yes , everything is ok. TCP/IP is enabled, and the rest values, the query
time is 600 (the default value), and the maximum users is (0, the default
value which means that are unlimited).
Any other idea ?
"Keith Wilson" <keithwi@.online.microsoft.com> escribi en el mensaje
news:4074336d$1@.news.microsoft.com...
> If you can you use Enterprise Manager from the W2003 server, please check
> the following:
> Launch the Properties dialog from the server object of Enterprise
Manager
> Select the Network Configuration button on the General tab
> Is TCP/IP enabled?
> Select the Connections tab
> Is the Query time-out value set too low?
> Is the maximum concurrent user connections value set too low?
>
> This posting is provided "AS IS" without express or implied warranty,
> guarantee, or rights.
> Keith Wilson
>
> "Charles" <ccolell@.softeng.es> wrote in message
> news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> that
>
Connection problem when registering a remote SQL2000
Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
Any idea ?If you can you use Enterprise Manager from the W2003 server, please check
the following:
Launch the Properties dialog from the server object of Enterprise Manager
Select the Network Configuration button on the General tab
Is TCP/IP enabled?
Select the Connections tab
Is the Query time-out value set too low?
Is the maximum concurrent user connections value set too low?
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
Keith Wilson
"Charles" <ccolell@.softeng.es> wrote in message
news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> Hello,
> I try to register a remote SQL Server 2000 installed in a W2003, but it
> doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
> In that network , port 1433 is open and what it really surpises me, is
that
> I can connect via ODBC to any database of that remote SQL Server2000 !!!
> Any idea ?
>|||Hello,
Yes , everything is ok. TCP/IP is enabled, and the rest values, the query
time is 600 (the default value), and the maximum users is (0, the default
value which means that are unlimited).
Any other idea ?
"Keith Wilson" <keithwi@.online.microsoft.com> escribi en el mensaje
news:4074336d$1@.news.microsoft.com...
> If you can you use Enterprise Manager from the W2003 server, please check
> the following:
> Launch the Properties dialog from the server object of Enterprise
Manager
> Select the Network Configuration button on the General tab
> Is TCP/IP enabled?
> Select the Connections tab
> Is the Query time-out value set too low?
> Is the maximum concurrent user connections value set too low?
>
> This posting is provided "AS IS" without express or implied warranty,
> guarantee, or rights.
> Keith Wilson
>
> "Charles" <ccolell@.softeng.es> wrote in message
> news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> that
>
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
Any idea ?If you can you use Enterprise Manager from the W2003 server, please check
the following:
Launch the Properties dialog from the server object of Enterprise Manager
Select the Network Configuration button on the General tab
Is TCP/IP enabled?
Select the Connections tab
Is the Query time-out value set too low?
Is the maximum concurrent user connections value set too low?
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
Keith Wilson
"Charles" <ccolell@.softeng.es> wrote in message
news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> Hello,
> I try to register a remote SQL Server 2000 installed in a W2003, but it
> doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
> In that network , port 1433 is open and what it really surpises me, is
that
> I can connect via ODBC to any database of that remote SQL Server2000 !!!
> Any idea ?
>|||Hello,
Yes , everything is ok. TCP/IP is enabled, and the rest values, the query
time is 600 (the default value), and the maximum users is (0, the default
value which means that are unlimited).
Any other idea ?
"Keith Wilson" <keithwi@.online.microsoft.com> escribi en el mensaje
news:4074336d$1@.news.microsoft.com...
> If you can you use Enterprise Manager from the W2003 server, please check
> the following:
> Launch the Properties dialog from the server object of Enterprise
Manager
> Select the Network Configuration button on the General tab
> Is TCP/IP enabled?
> Select the Connections tab
> Is the Query time-out value set too low?
> Is the maximum concurrent user connections value set too low?
>
> This posting is provided "AS IS" without express or implied warranty,
> guarantee, or rights.
> Keith Wilson
>
> "Charles" <ccolell@.softeng.es> wrote in message
> news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> that
>
Subscribe to:
Posts (Atom)