SQL Configure: March 2012

Tuesday 27 March 2012

Connect to SQL 2005 Mobile Edition

Hi,

I already have SQL Express Edition... i installed SQL 2005 Mobile Edition..
how could i connect to the mobile edition so i can design my DB?

The Visual Studio (post SP1) UI includes the ability to create and configure the schema of SQLCe databases. This can also be done in code or via synchronization. I describe all of these techniques in detail in my EBook. See www.hitchhikerguides.net.

Basically, you treat a SQLCe database like any other you create with Visual Studio.

hth

|||William are you going to write the next book on replication?
I brought your ebook and was eagerly awaiting the next one.

|||

Yes, I expect I won't get restarted on it until after TechEd and then only work on it part time. I want to put more time in on my novel.

|||

You're writing a novel about SQL Server?

--rj

Connect to SQL 2005 in Eclipse

I am trying to connect to Microsoft SQL Server 2005 through a program I am
writing in Eclipse and am having problems getting connected. I have already
created a database in Microsoft SQL Server 2005 and am trying to access that
database without having to get open the server. I have also downloaded the
Microsoft SQL Server 2005 JDBC driver. I have looked up several suggested
methods for connection and none of them have worked so far. I have recieved
several different errors for the different methods I have tried to use to
connect. I am unsure of what to do next.
Some of these errors are:
The TCP/IP connection to the host has failed. java.net.ConnectException:
Connection refused: connect
The connection to the named instance has failed. Error:
java.net.SocketTimeoutException: Receive timed out.
The TCP/IP connection to the host has failed. java.net.UnknownHostException
I am willing to try any other suggestions.
Thank you
I have figured out where my problem was. Thanks anyway.

Connect to SQL 2005 in Eclipse

I am trying to connect to Microsoft SQL Server 2005 through a program I am
writing in Eclipse and am having problems getting connected. I have already
created a database in Microsoft SQL Server 2005 and am trying to access that
database without having to get open the server. I have also downloaded the
Microsoft SQL Server 2005 JDBC driver. I have looked up several suggested
methods for connection and none of them have worked so far. I have recieved
several different errors for the different methods I have tried to use to
connect. I am unsure of what to do next.
Some of these errors are:
The TCP/IP connection to the host has failed. java.net.ConnectException:
Connection refused: connect
The connection to the named instance has failed. Error:
java.net.SocketTimeoutException: Receive timed out.
The TCP/IP connection to the host has failed. java.net.UnknownHostException
I am willing to try any other suggestions.
Thank youI have figured out where my problem was. Thanks anyway.

Connect to SQL 2005 from VB 6.0 with Ured ID and Passwoed

I am trying to connect to a SQL 2005 Database from VB 6.0. If I use windows
log on all works well. If I try to use SQL server logon I always get this
error:
(Login failed for user '<LoginName>'. Reason: Not associated with a trusted
SQL Server connection)
I have setup many users in the Server security section and in my database
user section. All have full rights but still cannot log on. The Server is
set up in dual mode Windows and SQL
The SQL 2005 is running on Windows XP pro, not a server.
Thanks,
Bob Hiller
> I am trying to connect to a SQL 2005 Database from VB 6.0. If I use
> windows
> log on all works well. If I try to use SQL server logon I always get
> this
> error:
> (Login failed for user '<LoginName>'. Reason: Not associated with a
> trusted
> SQL Server connection)
> I have setup many users in the Server security section and in my
> database
> user section. All have full rights but still cannot log on. The Server
> is
> set up in dual mode Windows and SQL
> The SQL 2005 is running on Windows XP pro, not a server.
May you post the full connectionstring you are using?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
sql sql

Connect to SQL 2005 from VB 6.0 with Ured ID and Passwoed

I am trying to connect to a SQL 2005 Database from VB 6.0. If I use windows
log on all works well. If I try to use SQL server logon I always get this
error:
(Login failed for user '<LoginName>'. Reason: Not associated with a trusted
SQL Server connection)
I have setup many users in the Server security section and in my database
user section. All have full rights but still cannot log on. The Server is
set up in dual mode Windows and SQL
The SQL 2005 is running on Windows XP pro, not a server.
Thanks,
Bob Hiller> I am trying to connect to a SQL 2005 Database from VB 6.0. If I use
> windows
> log on all works well. If I try to use SQL server logon I always get
> this
> error:
> (Login failed for user '<LoginName>'. Reason: Not associated with a
> trusted
> SQL Server connection)
> I have setup many users in the Server security section and in my
> database
> user section. All have full rights but still cannot log on. The Server
> is
> set up in dual mode Windows and SQL
> The SQL 2005 is running on Windows XP pro, not a server.
May you post the full connectionstring you are using?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

connect to SQL 2005 fails

We have a test SQL 2005 (Developer Edition) machine on Windows2003 SP1
Standard Edition. After the reboot to install MS patches Tuesday AM, it qui
t
accepting any SQL Connections. Prior to the reboot it was accepting
connections and working as we expected it to. I've worked with the Surface
Area configuration tool to make sure it allows connections. We've backed ou
t
the patches. After doing this, we've rebooted the box. Yet, we still are
unable to connect.
The primary error message we are seeing is "A connection was successfully
established with the server, but then an error occurred during the pre-login
handshake. (provider: Shared Memory Provider, error: 0 - No process is on th
e
other end of the pipe.) (type SqlException)"
I am also seeing "A connection was successfully established with the server,
but then an error occurred during the pre-login handshake. (provider: Shared
Memory Provider, error: 0 - No process is on the other end of the pipe.)
(Microsoft SQL Server, Error: 233)"
In addition to SQL2005, we have TFS, Windows SharePointServices, and
Reporting Services running on the machine. They are all experiencing
variations on the same message and unable to connect.
Thanks for the assistance.
JeffSounds like the SQL Server service didn't restart after the reboot. Check
the log at:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
to see if there is a problem with SQL restarting. If that doesn't work, try
using the SQL Server Configuration Manager tool to enable the TCP/IP
protocol on the client and server to see if the problem is isolated to named
pipes.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Jeff in Alaska" <Jeff in Alaska@.discussions.microsoft.com> wrote in message
news:577AE98A-4170-4C15-859B-1FAA0D89A658@.microsoft.com...
> We have a test SQL 2005 (Developer Edition) machine on Windows2003 SP1
> Standard Edition. After the reboot to install MS patches Tuesday AM, it
> quit
> accepting any SQL Connections. Prior to the reboot it was accepting
> connections and working as we expected it to. I've worked with the
> Surface
> Area configuration tool to make sure it allows connections. We've backed
> out
> the patches. After doing this, we've rebooted the box. Yet, we still are
> unable to connect.
> The primary error message we are seeing is "A connection was successfully
> established with the server, but then an error occurred during the
> pre-login
> handshake. (provider: Shared Memory Provider, error: 0 - No process is on
> the
> other end of the pipe.) (type SqlException)"
> I am also seeing "A connection was successfully established with the
> server,
> but then an error occurred during the pre-login handshake. (provider:
> Shared
> Memory Provider, error: 0 - No process is on the other end of the pipe.)
> (Microsoft SQL Server, Error: 233)"
> In addition to SQL2005, we have TFS, Windows SharePointServices, and
> Reporting Services running on the machine. They are all experiencing
> variations on the same message and unable to connect.
> Thanks for the assistance.
> Jeff|||SQL Server successfully restarted. The SQLFT*.LOG and ERRORLOG files both
indicate a successful restart. On the SQL Server Confiruation Manager tool
"Shared Memory", "Named Pipes" and "TCP/IP" are all enabled. "TCP/IP" is
enabled to listen on all IP Addresses. The machine only has one IP that it
is listening to. The protocol order is Shared Memory, TCP/IP, and Named
Pipes.
When looking at the Process view and the "System Services" view, both
indicate SQL Server is up and operational. the only SQL related tool that
isn't operational is SQL Server Agent and it is failing due to same problems
that cause other apps trying to connect to the SQL Server to fail.
Jeff
"Roger Wolter[MSFT]" wrote:

> Sounds like the SQL Server service didn't restart after the reboot. Check
> the log at:
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
> to see if there is a problem with SQL restarting. If that doesn't work, t
ry
> using the SQL Server Configuration Manager tool to enable the TCP/IP
> protocol on the client and server to see if the problem is isolated to nam
ed
> pipes.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Jeff in Alaska" <Jeff in Alaska@.discussions.microsoft.com> wrote in messa
ge
> news:577AE98A-4170-4C15-859B-1FAA0D89A658@.microsoft.com...
>
>|||I can connect easily using C# & ADO.NET on standalone programs.
I am trying to connect from a web site program under .NET 1.1 VS 7 and
always get
Login failed for user 'LANDON\ASPNET'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information abou
t
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'LANDON\ASPNET'.
Source Error:
Line 46: private void Page_Load(object sender, System.EventArgs e)
Line 47: {
Line 48: sqlConnection1.Open();
Line 49: ds = new DataSet();
Line 50: daAttendees = new SqlDataAdapter(
Source File: c:\inetpub\wwwroot\pcswebapp2\webform1.aspx.cs Line: 48
having signed in under IE6 using:
http://localhost/PCSWebApp2/WebForm1.aspx
I've tried everything to fix the problem;
"Jeff in Alaska" wrote:
[vbcol=seagreen]
> SQL Server successfully restarted. The SQLFT*.LOG and ERRORLOG files both
> indicate a successful restart. On the SQL Server Confiruation Manager too
l
> "Shared Memory", "Named Pipes" and "TCP/IP" are all enabled. "TCP/IP" is
> enabled to listen on all IP Addresses. The machine only has one IP that i
t
> is listening to. The protocol order is Shared Memory, TCP/IP, and Named
> Pipes.
> When looking at the Process view and the "System Services" view, both
> indicate SQL Server is up and operational. the only SQL related tool that
> isn't operational is SQL Server Agent and it is failing due to same proble
ms
> that cause other apps trying to connect to the SQL Server to fail.
> Jeff
> "Roger Wolter[MSFT]" wrote:
>|||"Landon Kelsey" <landonmkelsey@.hotmail.com> wrote in message
news:AC0C18EB-405E-4C5E-8148-FBAA18C12A46@.microsoft.com...[vbcol=seagreen]
>I can connect easily using C# & ADO.NET on standalone programs.
> I am trying to connect from a web site program under .NET 1.1 VS 7 and
> always get
> Login failed for user 'LANDON\ASPNET'.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Data.SqlClient.SqlException: Login failed for
> user
> 'LANDON\ASPNET'.
> Source Error:
>
> Line 46: private void Page_Load(object sender, System.EventArgs e)
> Line 47: {
> Line 48: sqlConnection1.Open();
> Line 49: ds = new DataSet();
> Line 50: daAttendees = new SqlDataAdapter(
>
> Source File: c:\inetpub\wwwroot\pcswebapp2\webform1.aspx.cs Line: 48
> having signed in under IE6 using:
> http://localhost/PCSWebApp2/WebForm1.aspx
> I've tried everything to fix the problem;
>
>
>
> "Jeff in Alaska" wrote:
>
Is there any reason you've hijacked several other OP's posts instead of
posting your own message?
Star Fleet Admiral Q @. your service!
Google is your friend!
http://www.google.com|||this problem appears in more than one post so why dilute the
knowledge/proliferate the problem by starting yet another post?
I've noticed that good answewrs have been given in one of the posts.
Do you expect the answerer to search for every post of the problem and
answer it?
"Admiral Q" wrote:

> "Landon Kelsey" <landonmkelsey@.hotmail.com> wrote in message
> news:AC0C18EB-405E-4C5E-8148-FBAA18C12A46@.microsoft.com...
>
> Is there any reason you've hijacked several other OP's posts instead of
> posting your own message?
> --
> Star Fleet Admiral Q @. your service!
> Google is your friend!
> http://www.google.com
>
>|||"Landon Kelsey" <landonmkelsey@.hotmail.com> wrote in message
news:8D5862C0-755A-4523-81B4-CBF7A69686D6@.microsoft.com...[vbcol=seagreen]
> this problem appears in more than one post so why dilute the
> knowledge/proliferate the problem by starting yet another post?
> I've noticed that good answewrs have been given in one of the posts.
> Do you expect the answerer to search for every post of the problem and
> answer it?
> "Admiral Q" wrote:
>
Guess you'll find out you won't get many of your own questions asked if you
keep hijacking other threads - as soon as you learn proper neticate, you'll
get the results you desire, but until then, you'll be living on other's
crumbs.
Star Fleet Admiral Q @. your service!
Google is your friend!
http://www.google.com|||Hey, u had a question and then u found your self arguing on some post
made by a person who got lost maybe (with the mind). I have the same
problem described pretty good in the first post. And I can't solve it.
I really don't want to reinstall my OS or even Sql Server 2005. If by
some miracle someone knows about the problem "give me a call".
Here's the problem described by sql server:
Code:
--
===================================
Cannot connect to NELUSAN\SQLSERVER2005.
===================================
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: Shared Memory Provider,
error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Dat
a Provider)
For help, click: http://go.microsoft.com/fwlink?Prod...33&LinkId=20476
Server Name: NELUSAN\SQLSERVER2005
Error Number: 233
Severity: 20
State: 0
Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exceptio
n, Boolean breakConnection)
at System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
b
ject stateObj)
at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt,
Boolean trustServerCert, Boolean& marsCapable)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Bool
ean& failoverDemandDone, String host, String failoverPartner, String protoco
l, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt,
Boolean trustServerCert,
Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnect
ion owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIden
tity identity, SqlConnectionString connectionOptions, Object providerInfo, S
tring newPassword, SqlConnection owningObject, Boolean redirectedUserInstanc
e)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionO
ptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConne
ction owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(Db
Connection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection o
wningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection o
uterConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExpl
orer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThrea
dUser()
--
nelusan
---
nelusan's Profile: http://www.dbtalk.net/m400
View this thread: http://www.dbtalk.net/t300721

connect to sql

Hi
I have two machine one is application server (asp) and one is database
server (sql 2000).
Between them, I use a crossover cable connect each other(1GB) and also they'
re all connect to internet use another network card(100 MB).
I test locally and the speed is good, but just found it's very slow after we
moved the machined to the collocation. How to trouble this? Please help.
just found out use name instead of ip and change from to SQLOLEDB
provider=SQLOLEDB.1 and it works fine.
why is that? please advice.
<js@.someone.com> wrote in message
news:eyKXm6r8GHA.4708@.TK2MSFTNGP05.phx.gbl...
> Hi
>
> I have two machine one is application server (asp) and one is database
> server (sql 2000).
> Between them, I use a crossover cable connect each other(1GB) and also
they'
> re all connect to internet use another network card(100 MB).
> I test locally and the speed is good, but just found it's very slow after
we
> moved the machined to the collocation. How to trouble this? Please help.
>
>
|||It affects things when you have more than two version on the
computer. If you use just SQLOLEDB, it will point to the
latest version of the provider. When you use SQLOLEDB.1, you
are specifying a specific version with the ProgID.
You may want to use the MDAC Component Checker to check your
MDAC installation. You can download it from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Wed, 18 Oct 2006 12:54:57 -0400, <js@.someone.com> wrote:

>just found out use name instead of ip and change from to SQLOLEDB
>provider=SQLOLEDB.1 and it works fine.
>why is that? please advice.
><js@.someone.com> wrote in message
>news:eyKXm6r8GHA.4708@.TK2MSFTNGP05.phx.gbl...
>they'
>we
>

Sunday 25 March 2012

connect to sql

Hi
I have two machine one is application server (asp) and one is database
server (sql 2000).
Between them, I use a crossover cable connect each other(1GB) and also they'
re all connect to internet use another network card(100 MB).
I test locally and the speed is good, but just found it's very slow after we
moved the machined to the collocation. How to trouble this? Please help.just found out use name instead of ip and change from to SQLOLEDB
provider=SQLOLEDB.1 and it works fine.
why is that? please advice.
<js@.someone.com> wrote in message
news:eyKXm6r8GHA.4708@.TK2MSFTNGP05.phx.gbl...
> Hi
>
> I have two machine one is application server (asp) and one is database
> server (sql 2000).
> Between them, I use a crossover cable connect each other(1GB) and also
they'
> re all connect to internet use another network card(100 MB).
> I test locally and the speed is good, but just found it's very slow after
we
> moved the machined to the collocation. How to trouble this? Please help.
>
>|||It affects things when you have more than two version on the
computer. If you use just SQLOLEDB, it will point to the
latest version of the provider. When you use SQLOLEDB.1, you
are specifying a specific version with the ProgID.
You may want to use the MDAC Component Checker to check your
MDAC installation. You can download it from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Wed, 18 Oct 2006 12:54:57 -0400, <js@.someone.com> wrote:

>just found out use name instead of ip and change from to SQLOLEDB
>provider=SQLOLEDB.1 and it works fine.
>why is that? please advice.
><js@.someone.com> wrote in message
>news:eyKXm6r8GHA.4708@.TK2MSFTNGP05.phx.gbl...
>they'
>we
>

Connect to specific TCP/IP endpoint?

Hello All,
I'd read in BOL that it is possible to connect "explicitly" to a
specific TCP/IP endpoint on the server. Does anyone know how to do
this? I can't find an example anywhere.
Thanks in advance.
-KJIn Enterprise manager, when you connect to a new server in a server group
enter the IP address of your server instead of the server's network name. If
your server is behind a firewall, you would have to implement NAT to the
actual server's Internal server's private IP address using port 1433 (the
default). Enter your EXTERNAL IP address as the server's address in the Ent
mgr in this case.
This way you can control a sql server from anywhere, but be aware that you
are opening a dangerous door. You should have a firewall that allows you to
filter the origin of the calls on port 1433 and only allow those requests
that originate from your safe Ip addresses to go through, that means that
your Ip address from which you make the calls should be a fixed IP. (costs
more)
HTH
Bob
"KJ" <n_o_s_p_a__m@.mail.com> wrote in message
news:1151340328.957952.169780@.c74g2000cwc.googlegroups.com...
> Hello All,
> I'd read in BOL that it is possible to connect "explicitly" to a
> specific TCP/IP endpoint on the server. Does anyone know how to do
> this? I can't find an example anywhere.
> Thanks in advance.
> -KJ
>|||I should have stated that I am actually looking for information on
connecting to TCP/IP endpoints (default or user-created) in SQL Server
2005.
Thanks Bob for your reply.
Bob wrote:
> In Enterprise manager, when you connect to a new server in a server group
> enter the IP address of your server instead of the server's network name.
If
> your server is behind a firewall, you would have to implement NAT to the
> actual server's Internal server's private IP address using port 1433 (the
> default). Enter your EXTERNAL IP address as the server's address in the En
t
> mgr in this case.
> This way you can control a sql server from anywhere, but be aware that you
> are opening a dangerous door. You should have a firewall that allows you t
o
> filter the origin of the calls on port 1433 and only allow those requests
> that originate from your safe Ip addresses to go through, that means that
> your Ip address from which you make the calls should be a fixed IP. (costs
> more)
> HTH
> Bob
>
> "KJ" <n_o_s_p_a__m@.mail.com> wrote in message
> news:1151340328.957952.169780@.c74g2000cwc.googlegroups.com...sql sql

connect to specific session using AMO?

The following works, but it uses AdomdClient to connect to a specific session. I'm wondering if there's a way to use AMO to connect to a specific session that already exists.

Dim server As New Microsoft.AnalysisServices.Server()

server.Connect("Data Source=myserver")

Dim sOldSession As String = server.SessionID

'do something

server.Disconnect(False) 'disconnect without killing the session

Dim conn As New Microsoft.AnalysisServices.AdomdClient.AdomdConnection("Data Source=myserver")

conn.SessionID = sOldSession

conn.Open() 'works

hello,

there should be a second overload of Server.Connect that accepts sessionId as a second argument.

so something like below should work:

Dim server As New Microsoft.AnalysisServices.Server()

server.Connect("Data Source=localhost")

Dim sOldSession As String = server.SessionID

'do something

server.Disconnect(False) 'disconnect without killing the session

Dim server2 As New Microsoft.AnalysisServices.Server()

server.Connect("Data Source=localhost", sOldSession)

'do something

server2.Disconnect()

hope this helps,

connect to server via intranet - how is it done (new to this)

Hi all!

I have msde2000 on one machine. want to connect to it from other machine. both machines are connected via a switch with integrated firewall.

Do I need to set up this firewall to enable connections? Like opening ports for msde in the virtual servers settings of the firewall?

If I do this, will that make my sql-server visible and accessible to the internet?

Or should I be able to find my sql server without such steps. And if so how?

networking is up and i can access folders of both machines via the intranet. Is that enough or do i need more settings here?

Let's say the machine and thus the server is called Alpha. What goes into my connectionstring from the other machine?

this wont be enough, right?
strconn = "Provider=SQLOLEDB;" & _
"Data Source="Alpha";"

Please shed some light on these questions.

tia

KumaFirst you will have to configure the ODBC settings in your machine. Make sure the datasource name is "alpha" , the same as the server name. You can then use "alpha" in the connection string. The code that is required is

'VB Code starts here

Set db = New ADODB.Connection

db.Properties("Data Source").Value = "alpha"
db.Properties("Initial Catalog").Value = "Northwind"
db.Properties("User ID").Value ="XXX"
db.Properties("Password").Value = "YYYYY"
db.Open

'ASP Code starts here
Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=SQLOLEDB;Data Source=alpha;Initial Catalog=Northwind;User Id=XXX;Password=YYY"

'CODE ENDS HERE

Roshmi Choudhury

CONNECT TO SERVER PROBLEM

I am getting this message when trying to connect to SQL SERVER 2005;
An error has occurred while establishing connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under default settings SQL Server does not allow remote connections(provider:shared memory provider , error 40-could not open a connection to SQL Server)(MicrosoftSQL SERVER, Error: 2)
Can anyone help to fix this problem please

Are you using SQL Express? If so, you need to enable remote connections. They are disabled by default.

Thanks,
Sam Lester (MSFT)

|||SQL SERVER 2005, STANDART
|||

On the server execute these statements:

sp_configure 'remote admin connections', 1

reconfigure

Then you should be able to connect from a client workstation.

connect to server name 2005!

First time I am using sql server 2005.
What is the default server name' I can not see anything in managment
studio.
whenever i tried to connect OR create database through SQL sever
Management studio, it asked me:
server type: (here i select Database Engine)
server Name : ( '')
Authentication : which one I have to use? (Windows Authentiction is by
default, another is SQL server Authentication,)...
I don't know what to do with server name . Please advise.Hi,
please do not mulitpost, answered in public.sqlserver
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
--

connect to server name 2005!

Connect to server from Report Builder

I am able to start Report Builder from the Reports site.

Report Builder opens but then it asks to "Select site or server", I don't see any data sources or anything, I can only enter a site or server. I tried http://crossdatabase/Reports and http://crossdatabase/ReportServer and http://crossdatabase nothing works. What's more, when I cancel and then click on the open button I get an exception:

Code Snippet

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.ReportBuilder.CatalogItemDialog.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
ReportBuilder
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Documents%20and%20Settings/Administrator.VDBRANDE/Local%20Settings/Apps/2.0/97YHGD67.7XE/97YX7M5J.5E2/repo..tion_c3bce3770c238a49_0009.0000_827b297b08a11874/ReportBuilder.exe
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
System.Deployment
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
-
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
-
System.Web.Services
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
-
yicgob7u
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
g5yh0wut
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
a0wegfwe
Assembly Version: 9.0.242.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

I run the Report Builder on the server so there should be no connection problems.

Thanks for any tips.

rept wrote:

I am able to start Report Builder from the Reports site.
Report Builder opens but then it asks to "Select site or server", I don't see any data sources or anything, I can only enter a site or server. I tried http://crossdatabase/Reports and http://crossdatabase/ReportServer and http://crossdatabase nothing works.

This doesn't work quite like you think it does.

In order for report builder to work properly, you need to create a Report Model Project in BIS. Once you've deployed a datasource, view and report model your report model will appear in the "select site or server" area in which you currently don't see anything.

The trick to defining the proper report model project is to define the proper relationships.

|||

Thanks for your help, I tried at first doing it in BIS but it doesn't seem possible to create a datasource based on OLAP in there? This is why I searched the net and found this tutorial which I'm trying to do:

http://msdn2.microsoft.com/en-us/library/ms345313.aspx

|||

Found the solution: I needed to open internet options in IE and then connections and check:

Bypass proxy server for local addressess. After that the Report Builder opened correctly and displayed the DSV perfectly.

connect to server from client

hi ,
i must to connect sql server that located in one domain from client that located the other domain.
please help me.
thanks alot:confused: :confused:if you are using server side authentication this is NOT a problem. Just define the login and access to the needed DB and you are ready to go.

If you are using NT authentication, you will need to have the user's domain trust the sql server's domain. I probably have that backwards but your network admin will know how to set the trusts up. After that you can define the login and continue as normal.

Can you give a little more detail about your problem?|||hi

I must connect to sql server by ODBC and when I define DSN i visited sql server in list but i meet this message"connection fail"

please guide me.

Connect to Server

Hi!

I m using VS2005 and SQL Server 2005 Express Edition For Database.

i want connect to the server with SQL Server Authentication, for this i created a account Name: ( Amit ) and assign the sysadmin security privleges.

whenever i try to connect with my account the below error comes:

TITLE: Connect to Server

Cannot connect to DOTNET\SQLEXPRESS.

ADDITIONAL INFORMATION:

Login failed for user 'amit'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

Please help it

Thanks

Amit

Can you post your connection string so that we can see how you are connecting.. Make sure that when you do post it change the server and usernames so that you do not make them puplic...

|||

This is probably due to the server being in integrated mode and the account being a sql login.

Switch the server to mixed mode and you should be able to connect.

-stevengo

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Amit,

To determine the source of the login failure, you need to look for the error state in the server's error log. Take a look at this blog posting for more info: http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Il-Sung.

Connect to remote SQL Server from local Web App

I have a SQL Server 2005 instance which resides on a dedicated server hosted by a third party. I am able to connect to this server through my local SQL Management Studio, however, my local ASP.NET 2.0 web application cannot connect. I get the error below. The connection string I use is formatted as...

Connection String:

Server=thesever;uid=myuserid;pwd=mypassword;database=mydatabase

Error:

Failed to connect to database: 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)

The hosting providr claims that the SQL Server configuration settings are as they should be as fars as TCP/IP and Named Pipes are concerned. Does anyone know what might be going on?

I believe I have found the problem. There was a problem creating the proper conneciton string.sql sql

Connect to remote SQL Server from behind ISA

Greetings.
I have a C# Windows app that connects to a remote SQL Server over the
Internet to download records. The application works great until a user
tries to run the query from behind ISA. Is there anything I can do in
the code or configure on the ISA box to allow the connection?
Thank you in advance for your help.
In message <1110557721.844982.74370@.z14g2000cwz.googlegroups. com>,
HardBap <hardbap@.gmail.com> writes
>Greetings.
>I have a C# Windows app that connects to a remote SQL Server over the
>Internet to download records. The application works great until a user
>tries to run the query from behind ISA. Is there anything I can do in
>the code or configure on the ISA box to allow the connection?
>Thank you in advance for your help.
>
You will probably need to add some packet filters into ISA to open the
ports being used for the connection etc.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

Connect to remote SQL Server from behind ISA

Greetings.
I have a C# Windows app that connects to a remote SQL Server over the
Internet to download records. The application works great until a user
tries to run the query from behind ISA. Is there anything I can do in
the code or configure on the ISA box to allow the connection?
Thank you in advance for your help.In message <1110557721.844982.74370@.z14g2000cwz.googlegroups.com>,
HardBap <hardbap@.gmail.com> writes
>Greetings.
>I have a C# Windows app that connects to a remote SQL Server over the
>Internet to download records. The application works great until a user
>tries to run the query from behind ISA. Is there anything I can do in
>the code or configure on the ISA box to allow the connection?
>Thank you in advance for your help.
>
You will probably need to add some packet filters into ISA to open the
ports being used for the connection etc.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

Connect to remote SQL Server from behind ISA

Greetings.
I have a C# Windows app that connects to a remote SQL Server over the
Internet to download records. The application works great until a user
tries to run the query from behind ISA. Is there anything I can do in
the code or configure on the ISA box to allow the connection?
Thank you in advance for your help.In message <1110557721.844982.74370@.z14g2000cwz.googlegroups.com>,
HardBap <hardbap@.gmail.com> writes
>Greetings.
>I have a C# Windows app that connects to a remote SQL Server over the
>Internet to download records. The application works great until a user
>tries to run the query from behind ISA. Is there anything I can do in
>the code or configure on the ISA box to allow the connection?
>Thank you in advance for your help.
>
You will probably need to add some packet filters into ISA to open the
ports being used for the connection etc.
--
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

connect to remote sql server failed

I couldn’t connect to the sql server instance (10.192.130.80\development2 and
10.192.130.80\development3) remotely on enterprise manager and query
analyzer. The error is sql server does not exist or access denied. I setup
well in the client network utility and put sever name and port number in it.
But I still got same error. Could someone give me some tips what reason is?
thanks.
Can you ping those servers?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>
|||Yes, I can Ping them.
"Arnie Rowland" wrote:

> Can you ping those servers?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>
>
|||Is the SQL Server listening on TCP?
Check the SQL ERRORLOG for a line like:
SQL Server listening on tcp, shared memory, named pipes
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>

connect to remote sql server failed

I couldn’t connect to the sql server instance (10.192.130.80\development2
and
10.192.130.80\development3) remotely on enterprise manager and query
analyzer. The error is sql server does not exist or access denied. I setup
well in the client network utility and put sever name and port number in it.
But I still got same error. Could someone give me some tips what reason is?
thanks.Can you ping those servers?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>|||Yes, I can Ping them.
"Arnie Rowland" wrote:

> Can you ping those servers?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>
>|||Is the SQL Server listening on TCP?
Check the SQL ERRORLOG for a line like:
SQL Server listening on tcp, shared memory, named pipes
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>sql sql

Connect to Remote SQL SERVER Express 2005 server

I am trying to connect to a remote SQL Express server (using query analyzer)
and I am not able to. If I run SQL Server Managemant Studio I can connect
(using Windows Authentication). I have tried using the IP address of the
server and just the server name but no luck. There is only one instance
running on the server (default). This server is on a different subnet. The
error I receive is: Server: Msg 14, Level 16, State1
[microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
Any ideas?
TimAre you sure the SQL Express instance is the default? It normally installs
as a named instance SQLEXPRESS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>I am trying to connect to a remote SQL Express server (using query
>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>can connect (using Windows Authentication). I have tried using the IP
>address of the server and just the server name but no luck. There is only
>one instance running on the server (default). This server is on a
>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
> Any ideas?
> Tim
>|||You are right. When I try connecting using servername/sqlexpress I get the
following error:
[DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
Denied.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
> Are you sure the SQL Express instance is the default? It normally
> installs as a named instance SQLEXPRESS.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>|||How about servername\sqlexpress ? Is the SQLBrowser enabled and running on
the SQL Express server?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
> You are right. When I try connecting using servername/sqlexpress I get
> the following error:
> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
> Denied.
> Thanks,
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>|||Got the same error. I found a registry entry that fixed the problem.
HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo.
Added REG_SZ key <servername> with data set to:
<servername>,DBMSSOCN,<servername>,1433
Don't know what this does, but I am able to connect now.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uP3wAxRzGHA.2036@.TK2MSFTNGP05.phx.gbl...
> How about servername\sqlexpress ? Is the SQLBrowser enabled and running
> on the SQL Express server?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
>> You are right. When I try connecting using servername/sqlexpress I get
>> the following error:
>> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
>> Denied.
>> Thanks,
>>
>> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
>> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is
>>only one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>>
>

Connect to Remote SQL SERVER Express 2005 server

Connect to REMOTE SQL server

Hello!
I have a SQL server standard Edition installed in a Server, and the other
( Standard Edition - but only client tool) installed in a Client (using
Windows XP). Please tell me how to connect from Client computer to Server(
in local network) , When I was trying to connect, it could not connect and
return a message:" Can not found server. ConnectionOpen(Connect())"
Pls help me!
Thanks in advance!
Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
SQL Server MVP
"Chi Pheo" <chipheo2k@.mail.ru> wrote in message
news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hello!
> I have a SQL server standard Edition installed in a Server, and the other
> ( Standard Edition - but only client tool) installed in a Client (using
> Windows XP). Please tell me how to connect from Client computer to Server(
> in local network) , When I was trying to connect, it could not connect and
> return a message:" Can not found server. ConnectionOpen(Connect())"
> Pls help me!
> Thanks in advance!
>
|||Hi, Thanks so much!
But nothing better.
My SQL Server is installed in a Computer with Win 2000 server , to access to
this Computer (in local network) I must log in as Administrator (means that,
when i use Windows Explorer, and type the IP address as 172.16.18.6, it
requires to enter user name, and i type Administrator). So I don't know if
it prevents us to connect to SQL server or not?
I tried to test by Ping 172.16.18.6, it's OK. I openned CLient Network
utility and in TCP/IP, I type Alias MyServer, IP: 172.16.18.6 and port 1433.
But when I connect as "sa", it shows: login failed for 'sa'. Not associated
with a trusted SQL server connection.
Thanks for all your helps!
"Hari Prasad" <hari_prasad_k@.hotmail.com> /
: news:uCmhJq6vEHA.4028@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Hi,
> This error can come in below situations:-
> 1. SQL Server is down
> 2. Your client network issues. Try a ping to server and check the network
> connection
> 3. Providing wrong SQL server name.
> If all the above is OK, then create a ALIAS server name using the CLient
> network utility specifying protocol as TCIP , IP address , port number.
> After that try to connect using that ALIAS name.
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "Chi Pheo" <chipheo2k@.mail.ru> wrote in message
> news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
other[vbcol=seagreen]
Server([vbcol=seagreen]
and
>

Connect to REMOTE SQL server

Hello!
I have a SQL server standard Edition installed in a Server, and the other
( Standard Edition - but only client tool) installed in a Client (using
Windows XP). Please tell me how to connect from Client computer to Server(
in local network) , When I was trying to connect, it could not connect and
return a message:" Can not found server. ConnectionOpen(Connect())"
Pls help me!
Thanks in advance!Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
SQL Server MVP
"Chi Pheo" <chipheo2k@.mail.ru> wrote in message
news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hello!
> I have a SQL server standard Edition installed in a Server, and the other
> ( Standard Edition - but only client tool) installed in a Client (using
> Windows XP). Please tell me how to connect from Client computer to Server(
> in local network) , When I was trying to connect, it could not connect and
> return a message:" Can not found server. ConnectionOpen(Connect())"
> Pls help me!
> Thanks in advance!
>|||Hi, Thanks so much!
But nothing better.
My SQL Server is installed in a Computer with Win 2000 server , to access to
this Computer (in local network) I must log in as Administrator (means that,
when i use Windows Explorer, and type the IP address as 172.16.18.6, it
requires to enter user name, and i type Administrator). So I don't know if
it prevents us to connect to SQL server or not'
I tried to test by Ping 172.16.18.6, it's OK. I openned CLient Network
utility and in TCP/IP, I type Alias MyServer, IP: 172.16.18.6 and port 1433.
But when I connect as "sa", it shows: login failed for 'sa'. Not associated
with a trusted SQL server connection.
Thanks for all your helps!
"Hari Prasad" <hari_prasad_k@.hotmail.com> /
: news:uCmhJq6vEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi,
> This error can come in below situations:-
> 1. SQL Server is down
> 2. Your client network issues. Try a ping to server and check the network
> connection
> 3. Providing wrong SQL server name.
> If all the above is OK, then create a ALIAS server name using the CLient
> network utility specifying protocol as TCIP , IP address , port number.
> After that try to connect using that ALIAS name.
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "Chi Pheo" <chipheo2k@.mail.ru> wrote in message
> news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
other[vbcol=seagreen]
Server([vbcol=seagreen]
and[vbcol=seagreen]
>

Connect to REMOTE SQL server

Hello!
I have a SQL server standard Edition installed in a Server, and the other
( Standard Edition - but only client tool) installed in a Client (using
Windows XP). Please tell me how to connect from Client computer to Server(
in local network) , When I was trying to connect, it could not connect and
return a message:" Can not found server. ConnectionOpen(Connect())"
Pls help me!
Thanks in advance!Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
SQL Server MVP
"Chi Pheo" <chipheo2k@.mail.ru> wrote in message
news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
> Hello!
> I have a SQL server standard Edition installed in a Server, and the other
> ( Standard Edition - but only client tool) installed in a Client (using
> Windows XP). Please tell me how to connect from Client computer to Server(
> in local network) , When I was trying to connect, it could not connect and
> return a message:" Can not found server. ConnectionOpen(Connect())"
> Pls help me!
> Thanks in advance!
>|||Hi, Thanks so much!
But nothing better.
My SQL Server is installed in a Computer with Win 2000 server , to access to
this Computer (in local network) I must log in as Administrator (means that,
when i use Windows Explorer, and type the IP address as 172.16.18.6, it
requires to enter user name, and i type Administrator). So I don't know if
it prevents us to connect to SQL server or not'
I tried to test by Ping 172.16.18.6, it's OK. I openned CLient Network
utility and in TCP/IP, I type Alias MyServer, IP: 172.16.18.6 and port 1433.
But when I connect as "sa", it shows: login failed for 'sa'. Not associated
with a trusted SQL server connection.
Thanks for all your helps!
"Hari Prasad" <hari_prasad_k@.hotmail.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:uCmhJq6vEHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi,
> This error can come in below situations:-
> 1. SQL Server is down
> 2. Your client network issues. Try a ping to server and check the network
> connection
> 3. Providing wrong SQL server name.
> If all the above is OK, then create a ALIAS server name using the CLient
> network utility specifying protocol as TCIP , IP address , port number.
> After that try to connect using that ALIAS name.
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "Chi Pheo" <chipheo2k@.mail.ru> wrote in message
> news:e0oYy44vEHA.824@.TK2MSFTNGP11.phx.gbl...
> > Hello!
> > I have a SQL server standard Edition installed in a Server, and the
other
> > ( Standard Edition - but only client tool) installed in a Client (using
> > Windows XP). Please tell me how to connect from Client computer to
Server(
> > in local network) , When I was trying to connect, it could not connect
and
> > return a message:" Can not found server. ConnectionOpen(Connect())"
> > Pls help me!
> > Thanks in advance!
> >
> >
>sql sql

Connect to remote server

From Enterprise Manager on my PC, how do I connect to a remote server over
the internet - I have the IP address, User Name and Password.

ThanksWhen creating an SQL connection using SQL Server EM you will need to:

Configure the server alias
Create the SQL connection.

Configure the Server alias

Open SQL Server Client Network Utility.
When Client Network Utility opens, click on the Alias tab.
Click on the Add button.
In the Server Alias text box enter a name for your SQL connection.
Select TCP/IP under Network libraries
Enter the IP address of the Server your SQL database is located on, in
the Server name text box.
Click on the OK button.
Your Server alias will now be configured, click on the Apply button.
Click on the OK button.

Create Connection

Open SQL Server Enterprise Manager
When Enterprise Manager opens, right click SQL Server Group and select
New SQL Server Registration.
The Register SQL Server wizard will now open.
Click on the Next button.
>From the Available Servers drop down menu, select the server alias you
created earlier.
Click on the Add button.
The server should now be listed under Added servers, click on the Next
button.
When the next dialog box appears select 'The SQL Server login
information that was assigned to me by the system administrator' (see
above).
Click on the Next button.
Enter your Login name and Password - this will be used every time you
connect to your SQL server. Click on the Next button.
Ensure that 'Add the SQL Server(s) to an existing SQL Server group' is
selected and 'SQL Server Group' is selected for Group name.

Click on the Next button.
When the next dialog box opens you can click on the Finish button.
Your SQL Connection will now be created.

HTH
Paul|||Paul

That works fine, thanks.

<stpaul_71@.yahoo.com> wrote in message
news:1102537081.548714.60980@.z14g2000cwz.googlegro ups.com...
> When creating an SQL connection using SQL Server EM you will need to:
> Configure the server alias
> Create the SQL connection.
> Configure the Server alias
> Open SQL Server Client Network Utility.
> When Client Network Utility opens, click on the Alias tab.
> Click on the Add button.
> In the Server Alias text box enter a name for your SQL connection.
> Select TCP/IP under Network libraries
> Enter the IP address of the Server your SQL database is located on, in
> the Server name text box.
> Click on the OK button.
> Your Server alias will now be configured, click on the Apply button.
> Click on the OK button.
>
> Create Connection
> Open SQL Server Enterprise Manager
> When Enterprise Manager opens, right click SQL Server Group and select
> New SQL Server Registration.
> The Register SQL Server wizard will now open.
> Click on the Next button.
>>From the Available Servers drop down menu, select the server alias you
> created earlier.
> Click on the Add button.
> The server should now be listed under Added servers, click on the Next
> button.
> When the next dialog box appears select 'The SQL Server login
> information that was assigned to me by the system administrator' (see
> above).
> Click on the Next button.
> Enter your Login name and Password - this will be used every time you
> connect to your SQL server. Click on the Next button.
> Ensure that 'Add the SQL Server(s) to an existing SQL Server group' is
> selected and 'SQL Server Group' is selected for Group name.
> Click on the Next button.
> When the next dialog box opens you can click on the Finish button.
> Your SQL Connection will now be created.
>
> HTH
> Paul

Connect to remote RS in SSMS

Got following error when try to connect to remote reporting service in SSMS:

TITLE: Microsoft SQL Server Management Studio

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that? Thanks.

Odd - You're logged in on as the same user on both computers? Are both computers in the same domain?

Can you access the report server in a web browser from the remote computer?

If you can, try this:

in the SSMS connection dialog. Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

Does that work?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Yes, I can access the report server in a web browser from same remote computer where I tried to connect RS in SSMS. Replacing server name with RS url doesn't work either, got same 401 error.|||Is the user in the Administrators group on the box?|||Yes, it's local admin on both server and client machine.|||Very strange.. Since it is a 401 error, maybe you could look in the %windir%\system32\LogFiles\W3SVC1 for the latest log file to see what request is being denied.|||

Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine. Type in your windows credentials and see if you get the same error.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I found followings in the log file, any hint? By the way, got same error when try to connect with basic authentication. Thanks.

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

|||

Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory.

By default these are:

Report Manager: http://localhost/reports

Report Server: http://localhost/reportserver

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Worked with report server url, thanks for the help.|||Glad to see it worked for you.

Can you provide the IIS logs for when you try to connect using just

server\instance in the SSMS connection dialog. I'm curious to

know why you can't connect to RS with management studio.

Thanks,

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.|||

Did you ever find out why you couldn't just us the servername in SSMS? I am having this same problem.

Thanks,

Bryan

|||No, fine with me to use url.

Connect to remote RS in SSMS

Got following error when try to connect to remote reporting service in SSMS:

TITLE: Microsoft SQL Server Management Studio

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that? Thanks.

Odd - You're logged in on as the same user on both computers? Are both computers in the same domain?

Can you access the report server in a web browser from the remote computer?

If you can, try this:

in the SSMS connection dialog. Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

Does that work?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine. Type in your windows credentials and see if you get the same error.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I found followings in the log file, any hint? By the way, got same error when try to connect with basic authentication. Thanks.

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

|||

Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory.

By default these are:

Report Manager: http://localhost/reports

Report Server: http://localhost/reportserver

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Worked with report server url, thanks for the help.|||Glad to see it worked for you.
Can you provide the IIS logs for when you try to connect using just server\instance in the SSMS connection dialog. I'm curious to know why you can't connect to RS with management studio.
Thanks,
-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.|||

Did you ever find out why you couldn't just us the servername in SSMS? I am having this same problem.

Thanks,

Bryan

|||No, fine with me to use url.

Connect to remote RS in SSMS

Got following error when try to connect to remote reporting service in SSMS:

TITLE: Microsoft SQL Server Management Studio

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that? Thanks.

Odd - You're logged in on as the same user on both computers? Are both computers in the same domain?

Can you access the report server in a web browser from the remote computer?

If you can, try this:

in the SSMS connection dialog. Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

Does that work?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine. Type in your windows credentials and see if you get the same error.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I found followings in the log file, any hint? By the way, got same error when try to connect with basic authentication. Thanks.

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

|||

Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory.

By default these are:

Report Manager: http://localhost/reports

Report Server: http://localhost/reportserver

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

Did you ever find out why you couldn't just us the servername in SSMS? I am having this same problem.

Thanks,

Bryan

|||No, fine with me to use url.

Connect to remote RS in SSMS

Got following error when try to connect to remote reporting service in SSMS:

TITLE: Microsoft SQL Server Management Studio

The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same account in both case. How to configure that? Thanks.

Odd - You're logged in on as the same user on both computers? Are both computers in the same domain?

Can you access the report server in a web browser from the remote computer?

If you can, try this:

in the SSMS connection dialog. Replace machine\instance in the server textbox with the URL to your report server, e.g. http://yourserver/reportserver.

Does that work?

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

Another thing to try is to change the Authentication Type to Digest in Management Studio when logging in from the remote machine. Type in your windows credentials and see if you get the same error.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I found followings in the log file, any hint? By the way, got same error when try to connect with basic authentication. Thanks.

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 2 2148074254

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 - 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401 1 0

2005-12-30 14:15:33 172.20.193.76 GET /reportsdr - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 301 0 0

2005-12-30 14:15:55 172.20.193.76 GET /reportsdr/home.aspx - 80 corp\rmiao 10.16.55.81 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 302 0 0

|||

Looks like you're passing the Report Manager virutal directory. You need to pass the report server virtual directory.

By default these are:

Report Manager: http://localhost/reports

Report Server: http://localhost/reportserver

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

Did you ever find out why you couldn't just us the servername in SSMS? I am having this same problem.

Thanks,

Bryan

|||No, fine with me to use url.sql sql

Connect to remote MYSQL From the local mssql

Connect to remote MYSQL From the local mssqlOn Fri, 21 Dec 2007 03:51:41 -0800 (PST), zhuxingsheng@.gmail.com
wrote:

By creating a Linked Server? Look it up in Books Online.
-Tom.

Quote:

Originally Posted by

>how ?

|||On 21.12.2007 12:51, zhuxingsheng@.gmail.com wrote:

Quote:

Originally Posted by

how ?

You picked the wrong group.

robert|||On Dec 21, 1:51 pm, zhuxingsh...@.gmail.com wrote:

Quote:

Originally Posted by

how ?

Use Linked Servers!|||On 22.12.2007 18:57, Robert Klemme wrote:

Quote:

Originally Posted by

On 21.12.2007 12:51, zhuxingsheng@.gmail.com wrote:

Quote:

Originally Posted by

>how ?

>
You picked the wrong group.

Sorry, I just recognize I made a complete fool out of myself. Please
just ignore my previous posting. Thank you!

Cheers

robert

Connect to remote instance of SSIS from SSMS using SQL Login?

I have installed a SQL Server 2005 Standard Edition instance with SSIS on Window Server 2003 x64. From my PC, I am able to connect to the Integration Services on the server using Windows Authentication but not with a local SQL login - and the option to change authentication methods is greyed out.

Is it possible to remotely connect to SSIS using a SQL login rather than a Windows login? If so, any ideas or references for configuring it as such?

Thanks.

- Lance

Per the post linked below, it's not supported.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=316143&SiteID=1

Connect to Remote Analysis Server

Hi,

How do I connect to a remote Analysis Server using SQL management studio on my local machine.

Thanks in advance..

Hi,

At the remote computer you want to connect, your nt domain username should be at least in the MSOLAPUser group. And if you want to have server-wide permissions your username should be added to the list displayed in the security tab of the olap server properties screen.

Eralper

http://www.kodyaz.com

|||Hi eralper,

Thanks for the reply. But how can my local SQL management studio detect Analysis Services of Network Servers? As of now, it can only detect Database Engines of other network server..

Thanks again...
|||

What is the name of the physical machine you want to connect to?

Also when it was installed was the instance given a name?

If the instance was not given a name then you can just put the machine name in the server edit control, if it has a name then it should be servername\instancename in the control.

|||

Maybe the Analysis Server is not configured to allow remote connections?

1. On the remote machine, start the SQL Server Surface Area Configuration tool and verify that remote connections are enabled.

2. On the remote machine, verify that the SQL Browser windows service is running.

3. If you have the Windows Firewall enabled on the local machine or remote machine, you will need to make sure you open TCP ports so Analysis Server can accept incoming connections. The port numbers Analysis Server listens to are following:
2383 – port default instance of Analysis Server listens to
2382 – port SQL Browser service listens to for Analysis Services requests.

Note: Named instance of Analysis Services will dynamically pick ports to listen on your machine. The easiest way to discover the TCP port the named instance is listening is to look at the configuration file for SQL Server Browser file. Open file located on the %Program files%\Microsoft SQL Server\90\Shared\ASConfig. Open msmdredir.ini file and look at the < Instances> section in it.
For example you might see following in it;
<Instances>
<Instance>
<Name>Inst1</Name>
<Port>56178</Port>
</Instance>
</Instances>

This means your machinename\Inst1 is listening on the port 56178.

In many situations you would like to ensure your named instance is not picking port by itself but listens on pre-defined port. For that, you can modify the Port – Analysis Server property. Make sure you restart Analysis Server and SQL Server Browser service after changing this property.

Hope this helps,

-- Robert

|||

Hi,

If you open the SQL Server Management Studio, open the Registered Servers screen and select Analysis Services.

If you try to add a new olap server, a list of available servers are listed in the dropdownlist. Or you can use the browse button. But I guess these are not coming from a network search process for available servers.

Sorry, I don't have an answer for that.

But I can suggest a tool which scans for sql servers within an IP range, SQLPing2 by C. Andrews from sqlsecurity.com

Unfortunately this tool does not search for the MS AS instances.

Eralper

http://www.kodyaz.com

Connect to remote analisys services 2000?

Hello, my ISP installed analisys services 2000 on the same server they have sql server 2000. They got lots of databases and installed it because I need it.

Anyway with analisys manager I try to regiser the server and I cant.

What do I need to configure on my machine and what else do they need to configure on their server? Do they need to send me some information besides the IP address?

This is the error:

error a conectar a server.dominio.com
no se puede abrir la conexion a server.dominio.com
error de red server.dominio.com

Analysis Services AS2k only works with NT authentication. The only way I know to make this work if your remote workstation and the server are in different domains is to set up matching local users.

Your ISP would need to set up a local user on the server and put that user in the OLAP Administrators group. You would then need to create a local user on your workstation with the same username and password and login using that user (or you might be able to use "Run As..." if you are using WinXP)

You will also need to make sure you have the same Analysis Services service pack on your workstation as is on the server, because Analysis Manager from one service pack often cannot talk to a server with a different service pack.

HTH

Regards
Darren
http://geekswithblogs.net/darrengosbell|||He is right. I get the same problem and this solution help me ;)

Regards,

Thiago
http://www.tritech.com.br

Connect to Read-Only Access database as linked server SQL 2005

Hi all,
I am trying to add an Access database as a linked server in SQL Server
2005.
For a "regular" database, everything works fine. BUT (there's a
but...) the database I'm trying to access is a "read-only" database
(i.e.: folder in which db is located is read-only). When I open it
from Access, it warns me that the db cannot be modified, bla bla bla.
I can access the data, but cannot make modifications to the structure
of the database (add queries, change tables, etc.).
So... my question is... Did I forget any parameter in the
sp_addlinkedserver procedure? Anytime I try to use the OpenQuery
method with this database I get the message
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "IVR_post"
returned message "The Microsoft Jet database engine cannot open the
file '\\CompletePathAndDatabaseName.mdb'
. It is already opened exclusively by another user, or you need
permission to view its data.".
However, like I said, the same db can be opened with access 2002 from
the same station, the same user, etc.
exec sp_addlinkedserver @.server='MyServer',
@.srvproduct='Access',
@.provider='Microsoft.Jet.OLEDB.4.0',
@.datasrc='\\CompletePathAndDatabaseName.mdb'
exec sp_addlinkedsrvlogin @.rmtsrvname='MyServer',
@.useself='false',
@.rmtuser='Admin',
@.rmtpassword=''
Regards,Hi,
I have replicated your problem and it works perfectly for me. Are you
sure that you don't have some issues with the Access lock file. If you
shut down all applications/clients/servers accessing this Access file,
does the .ldb file still show up?
Jonathan
fabien.turcotte@.fidomobile.ca wrote:
> Hi all,
> I am trying to add an Access database as a linked server in SQL Server
> 2005.
> For a "regular" database, everything works fine. BUT (there's a
> but...) the database I'm trying to access is a "read-only" database
> (i.e.: folder in which db is located is read-only). When I open it
> from Access, it warns me that the db cannot be modified, bla bla bla.
> I can access the data, but cannot make modifications to the structure
> of the database (add queries, change tables, etc.).
> So... my question is... Did I forget any parameter in the
> sp_addlinkedserver procedure? Anytime I try to use the OpenQuery
> method with this database I get the message
> OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "IVR_post"
> returned message "The Microsoft Jet database engine cannot open the
> file '\\CompletePathAndDatabaseName.mdb'
> . It is already opened exclusively by another user, or you need
> permission to view its data.".
> However, like I said, the same db can be opened with access 2002 from
> the same station, the same user, etc.
>
> exec sp_addlinkedserver @.server='MyServer',
> @.srvproduct='Access',
> @.provider='Microsoft.Jet.OLEDB.4.0',
> @.datasrc='\\CompletePathAndDatabaseName.mdb'
> exec sp_addlinkedsrvlogin @.rmtsrvname='MyServer',
> @.useself='false',
> @.rmtuser='Admin',
> @.rmtpassword=''
>
> Regards,
>sql sql

Tuesday 27 March 2012

Sunday 25 March 2012

Blog Archive

About Me