Error Locating Server/Instance Specified

I am having a problem connecting to my sql server express instance from a remote computer. I continue to get the above mentioned error. If I connect for the localhost everything works fine however when I try to connect from a different computer on the LAN it gives me this error. I have turned on remote access and still no luck. Any ideas? Any help would be appreciated.

Odds are you haven't created exceptions in the firewall on the remote computer to allow SQL to communicate through it. Check out the complete instructions for enableing remote connections to SQL Express in the KB, http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277.

FYI - This info is in the FAQ at the top of the forum is you need it again.

Mike

|||

Hi,

Ensure their is no network congesion between PCs you are connecting,

are they on same network segment !?

do you get ping acknoledgement when you ping your sql express from remote pc?

i would suggest you to refer http://support.microsoft.com/kb/905618/en-us also.

Hemantgiri S. Goswami

Error Locating Server/Instance Specified

I am having a problem connecting to my sql server express instance from a remote computer. I continue to get the above mentioned error. If I connect for the localhost everything works fine however when I try to connect from a different computer on the LAN it gives me this error. I have turned on remote access and still no luck. Any ideas? Any help would be appreciated.

Odds are you haven't created exceptions in the firewall on the remote computer to allow SQL to communicate through it. Check out the complete instructions for enableing remote connections to SQL Express in the KB, http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277.

FYI - This info is in the FAQ at the top of the forum is you need it again.

Mike

|||

Hi,

Ensure their is no network congesion between PCs you are connecting,

are they on same network segment !?

do you get ping acknoledgement when you ping your sql express from remote pc?

i would suggest you to refer http://support.microsoft.com/kb/905618/en-us also.

Hemantgiri S. Goswami

Error Installing Reporting Services

Hi all,
I'm currently installing Reporting Services Enterprise Edition in one
computer that use :
- Windows 2000 Server+SP4
- SQL Server Standard Edition
And I've got errors during installation :
Package 'VsRptDesigner Package' has failed to load properly ( GUID = ...
Package 'ACT Project Package' has failed to load properly ( GUID = ...
Package 'ReportDesignerPackage' has failed to load properly ( GUID = ...
Package 'DataWarehouse VSIntegration layer' has failed to load properly
( GUID = ...
Now, I cannot load Ms. Visual Studio.NET at all. My question is :
1. How to solve this problem?
2. Is it wrong to install Report Server, Report Manager & Report
Designer in one computer?
Please help,
ThanksLook here:
http://support.microsoft.com/?id=823245
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Resant" <resant_v@.yahoo.com> schrieb im Newsbeitrag
news:1113891129.326782.188330@.l41g2000cwc.googlegroups.com...
> Hi all,
> I'm currently installing Reporting Services Enterprise Edition in one
> computer that use :
> - Windows 2000 Server+SP4
> - SQL Server Standard Edition
> And I've got errors during installation :
> Package 'VsRptDesigner Package' has failed to load properly ( GUID => ...
> Package 'ACT Project Package' has failed to load properly ( GUID = ...
> Package 'ReportDesignerPackage' has failed to load properly ( GUID => ...
> Package 'DataWarehouse VSIntegration layer' has failed to load properly
> ( GUID = ...
> Now, I cannot load Ms. Visual Studio.NET at all. My question is :
> 1. How to solve this problem?
> 2. Is it wrong to install Report Server, Report Manager & Report
> Designer in one computer?
> Please help,
> Thanks
>|||Thanks for your answer.
I've tried that suggested solution before I post this question and
still doesn't work.
But the Protected Storage have ran already after VS.NET installation
but I restart it as wanted and nothing changed.
I forgot to mention that I've install VS.NET successfully at WinXP at
the same computer, but failed at Win 2000+SP4.
Any other suggestion?
Thanks|||Thanks for your answer.
I've tried that suggested solution before I post this question and
still doesn't work.
But the Protected Storage have ran already after VS.NET installation
but I restart it as wanted and nothing changed.
I forgot to mention that I've install VS.NET successfully at WinXP at
the same computer, but failed at Win 2000+SP4.
Any other suggestion?
Thanks

Error in the transport layer

Hello,

When i try to connect with excel with tcp/ip to an other computer where there is a cube, i've got this message:

'an error was encountered in the transport layer

Errors in the OLE DB provider

An error occured while loading the connection dialog box component for prompting'

I'm in mixed mode for the authentication and my user and password are in the olap administrator of the cube i want to browse.

I've got Windows XP sp2, SQL server 2005 Sp2 with SSAS developer edition, OWC 11.0 is installed and the OLE DB provider Analysis Service 9.0

Adriano.

There was an earlier thread on this topic that may provide some guidance:

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

B.

sql

Error in SQL 2005 Maintenance Plan

I'm trying to setup a nightly backup to a remote computer using an SQL
Server 2005 Maintenance Plan. It keeps giving an error. I've narrowed
the cause down to an execute command...
EXECUTE master.dbo.xp_create_subdir
N'\\\\10.2.32.15\\Backup_SQL2005\\\\IOC'
which is giving the error below...
Msg 22048, Level 16, State 1, Line 0
xp_create_subdir() returned error 123, 'The filename, directory name,
or volume label syntax is incorrect.'
I am signed on as administrator on both computers. I'm able to map a
drive though the Windows Explorer and create a subdirectory on the
remote machine.
I have also tried...
EXECUTE master.dbo.xp_create_subdir N'\\10.2.32.15\Backup_SQL2005\IOC'
EXECUTE master.dbo.xp_create_subdir N'\\GOMB-BACKUP\Backup_SQL2005\IOC'
EXECUTE master.dbo.xp_create_subdir N'G:\IOC' (after mapping a drive)
This works...
EXECUTE master.dbo.xp_create_subdir N'C:\IOC'
...but of course it's on the local computer.
Any ideas why this doesn't work?
Thanks,
CThe stuff you do in Explorer uses the Windows account *you* have logged in w
ith. The stuff that SQL
Server does uses the Service account for the SQL Server service. Verify that
the service account has
proper permissions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"The Cornjerker" <addoty@.gmail.com> wrote in message
news:1140218704.513963.300930@.g44g2000cwa.googlegroups.com...
> I'm trying to setup a nightly backup to a remote computer using an SQL
> Server 2005 Maintenance Plan. It keeps giving an error. I've narrowed
> the cause down to an execute command...
> EXECUTE master.dbo.xp_create_subdir
> N'\\\\10.2.32.15\\Backup_SQL2005\\\\IOC'
> which is giving the error below...
> Msg 22048, Level 16, State 1, Line 0
> xp_create_subdir() returned error 123, 'The filename, directory name,
> or volume label syntax is incorrect.'
> I am signed on as administrator on both computers. I'm able to map a
> drive though the Windows Explorer and create a subdirectory on the
> remote machine.
> I have also tried...
> EXECUTE master.dbo.xp_create_subdir N'\\10.2.32.15\Backup_SQL2005\IOC'
> EXECUTE master.dbo.xp_create_subdir N'\\GOMB-BACKUP\Backup_SQL2005\IOC'
> EXECUTE master.dbo.xp_create_subdir N'G:\IOC' (after mapping a drive)
> This works...
> EXECUTE master.dbo.xp_create_subdir N'C:\IOC'
> ...but of course it's on the local computer.
> Any ideas why this doesn't work?
> Thanks,
> C
>|||Tibor, thanks for the replay.
How do I give the Service account access to create remote
subdirectories?
C|||The Cornjerker (addoty@.gmail.com) writes:
> Tibor, thanks for the replay.
> How do I give the Service account access to create remote
> subdirectories?
As you would to for any other Windows user. (Which if you don't know is
a question for a Windows newsgroup. I hardly know it myself.)
Note howver, that you cannot do this if SQL Server is running under
Local System. In this case you need to change which account under which
SQL Server is running. To do this, right-click My Computer, select Manager,
find Services, and there find the SQL Server service. Double-click, and
log-on information is on the Log On tab.
If you are using SQL 2005, you should use the SQL Computer Manager instead.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland,
Thanks for the replay. Are there any divantages to running the
MSSQLSERVER service under the Administrator account?
C

error handling vbscript via sqlserver

Hi,

I wrote a small vbscript that sends information from a local computer to SQL server.
The method I use for connecting to the SQL server is via ODBC DSN.
This scripts runs on a DMZ located machine, while the SQL server is inside our LAN.

All works fine, but when the network connection between DMZ machine and SQL server lost
for a min. I receive an error.

I monitored the error and tried to error handle it.

after network is back the script is still on, but the error still there.

this is the part where I get the error:

-----------------------
Public function reso(byval res)

'error 3705 occurs here

objConn.Open strConn

Set objrs = objconn.Execute("exec cmp_creation "& Computer &"," & res)


objConn.Close

end function
-----------------------

Help would be much appreciatedWhy not use a DSN-less connection?

Also, if the server is in your DMZ and the SQL Server is behind a firewall (assumed), I would be sure to use the IP address instead of the network name.

Regards,

hmscott|||I'm not sure about the DSN-Less connection.... what would it change regarding my problem? also, what port do I have to open for a DSN-Less connection?|||I don't think that there's anything really wrong with a DSN connection and I'm not positive it would rectify your particular issue. However, DSN connections leave "footprints" on the server in your DMZ (in the registry) which are potentially vulnerable.

DSN and DSN-less connections use the same ports to connect to their respective data sources. Thus, a DSN connection to SQL Server would use port 1433 as would a DSN-less connection.

In general (from what I understand), DSN-less connections are "lighter" on the server, incurring less memory overhead. They are not, however, necessarily faster.

In your script, do you check for the state of the connection? Is it just opened once and left open? Or is it opened and closed as necessary?

Regards,

hmscott

Originally posted by eransp
I'm not sure about the DSN-Less connection.... what would it change regarding my problem? also, what port do I have to open for a DSN-Less connection?