Unable To Remotely Debug, And I Actually Tried

May 15, 2008

Hey everyone. I've been using .NET and SQL server for almost 2 years. I know most of the ins-and-outs, but we hit a bug that requires us to use remote debugging to track down. Like most people, remote debugging does not work out-of-box, but, I've actually tried most of the tips and I still cannot get it to work. Here is a summary of my problem:

------------------------------

Trying to remote debug a SQL Server 2005 database on a workgroup. I am not using CLR, just plain T-SQL.

In Visual Studio, I use the Server Explorer with a data-connection pointed to my remote server and it uses Windows Authentication. It correctly enumerates the available databases. "Step into Procedure" shows the "Run Stored Procedure" dialog with the various input/output parameters. Continuing, I get a dialog that says

"T-SQL execution ended without debugging. You may not have sufficient permissions to debug."



SQL Server is run under Windows Server 2003's window account: 'sqlusr'
Created user on local workstation called: 'sqlusr'
The 'sqlusr' on remote server and local workstation have same password, and are in the Administrator groups
'SERVERNAMEsqlusr' is in SQL Server's bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, serveradmin, setupadmin, and sysadmin roles
Simply running Visual Studio 2005 Professional as my local user does not allow me to authenticate with SQL Server. Running: 'runas /userqlusr "devenv.exe"' will let me authenticate. So - user authentication is apparently working.
I imagine that 'Remote Debugging Components' are installed, since msvsmon.exe is available on the server.
RPC and RPC Locator are running on remote server and local machine
There are no firewalls on the local workstation or remote server (Windows firewall is totally disabled, no 3rd parties..)
Debugging a local SQLEXPRESS database on my workstation works.
'SERVERNAMEsqlusr' has full control over the debugging folder: 'C:Program FilesCommon FilesMicrosoft SharedSQL Debugging'
I haven't seen any errors in the remote server's 'Event Viewer/Application' list
The Stored Proc name I am executing does not contain any single or double quotation marks
SQL Server and Windows Server both share the same name 'SERVERNAME'
Edited DCOM Access Limits and Launch Limits in both the workstation and local server. Allowed 'Remote Access' for Everyone
Any help? I'm out of ideas. Thanks in advance!

View 1 Replies


ADVERTISEMENT

Unable To Remotely Connect To SQL Exp

Aug 11, 2007

I have both the develper and sql express installed on my laptop computer. I also have Sql Express installed on my desktop computer( Did have develper installed but removed thinking the problem was in the install). I can connect via Management console from my Desktop to laptop with out any problems. I see databases etc. I can not connect from my laptop to desktop. I get a login error. From what I can tell, the servers are configed the same on both machines. I checked Firewall settings on both machines, even turned them both off with no results. Every time I try to connect from laptop I get Log in error, and I get "Failure Audit" eror under component services.

Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18456
Date: 11-Aug-07
Time: 07:24:50
User: LARRY-GATLINGuest
Computer: LARRY-GATLIN
Description:
Login failed for user 'LARRY-GATLINGuest'. [CLIENT: 192.168.1.102]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 18 00 00 00 4c 00 41 00 ....L.A.
0010: 52 00 52 00 59 00 2d 00 R.R.Y.-.
0018: 47 00 41 00 54 00 4c 00 G.A.T.L.
0020: 49 00 4e 00 5c 00 53 00 I.N..S.
0028: 51 00 4c 00 45 00 58 00 Q.L.E.X.
0030: 50 00 52 00 45 00 53 00 P.R.E.S.
0038: 53 00 00 00 07 00 00 00 S.......
0040: 6d 00 61 00 73 00 74 00 m.a.s.t.
0048: 65 00 72 00 00 00 e.r...


I am at a loss as to what is wrong. I am migrating my Database apps to Sql from Access and need to access remotely and locally, as well as do Replication. Any ideas?

Thanks
Larry Gatlin

View 12 Replies View Related

Unable To Access Web Application Remotely

Nov 2, 2006

I can't run my web application on remote pc which is connected in flan with my pc.It works on my local pc but it is not working on remote pc. i m geeting an error like as blowAn 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) i have used sql server 2000 for my database but i my getting error for sql server 2005 which i have never used in my web application.Here is the Exception detailsException Details: System.Data.SqlClient.SqlException: 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)i have used coonection string as followsData Source=neptune;Initial Catalog=azim;User ID=saso can anyone give me soluion of this problem 

View 1 Replies View Related

Unable To Start Sql Debug Session

Feb 27, 2004

Hi,

I get this error message each time i try to run the vb application in visual studio .net environment.
--------------------------------------------------------------------------------
"Unable to start SQL debug session. Ensure sqldbreg2.exe and proxy/stub DLL sqldbg.dll are registered on this machine"
-------------------------------------------------------------------------------

I am running visual studio and sql server 2000 on the same machine. I have given permission to sqldebugger user to access the system32 folder and sql debugging folder. This error message is followed by

-------------------------------------------------------------------------------
Attaching the T Sql debugger to process[proj1.exe] on machine 'my machine name' failed Error code 0x80004004
------------------------------------------------------------------------------

I am running MS SQL Server 2000 on windows 2000 adv server.

what can be done to remove this error. Thaks in advance

Sivaraj.

View 1 Replies View Related

Unable To Attach To Devenv.exe To Debug

Apr 5, 2006

Before I start peppering this forum with questions I'll start with one that might help me figure out others...

I'm trying to debug a custom component I'm developing. All the texts I've read state that the first thing I should do is attach to the devenv.exe process. When I choose this, the window that lists the available processes I can attach to does not contain devenv.exe.

Is this a security issue? Any other ideas? I'm an administrator on the box. Most of my career's been spent in UNIX environments, so perhaps I'm missing something basic I'm unaware of.

Thanks.

View 3 Replies View Related

Unable To Debug Using Reporting Services Process

May 17, 2007

I have written Custom delivery extension, I am trying to debug this by attching the process ReportingServicesService.exe , I am getting error "Unable to Attach to the Process.Access is denied". I am Admin on my sytem, ASP.net is also part of admin and debuggers group. I am using Visual studio 2005, reporting services 2005, ReportingServicesService.exe is also under my login



Any idea??

View 4 Replies View Related

Unable To Connect To SQL Server Express Locally Or Remotely

Jun 22, 2007

I have read all of the posts regarding this subject as well as 3"Dummies" guides and I keep having the same problems. I have a verysimple multi-user application that has to hit a database. Wecuerrently have this system deployed and it is working fine on adomain based network. We are scaling back and the network we will beusing is now a workgroup not a domain.It should be simple. I have XP boxes (clients) trying to hit the SQLServer Express database on a Windows Server 2003 machine. It is aclosed network so security is not an issue. I am trying to make thisthing wide open. All I want is for the user to be logged in on hisclient machine, run the application, and access/update the databasewithout having to re-authenticate to the SQL server. I want windowsto handle all of the authentication between the XP machines and theServer 2003 machine.Any suggestions would be greatly appreciated.

View 1 Replies View Related

Unable To Connect Remotely After Upgrading A SQL Instance From Express To Enterprise

Mar 4, 2007

Problem: I upgraded a SQL Server Express instance to SQL Server Enterprise, but I'm unable to connect to the SQL server from any remote machine. Only local connections work -- and I've verified that Remote Connections are allowed in the SQL Surface Confg. utility.

Scenario: Server1 has an SQL Enterprise edition installed as a default installation. SharePoint Server 2007 was installed later, and during that install a SQL Express edition instance was installed which is part of the standard SharePoint install. That Express instance contains all the SharePoint content databases.

So Server1 has SQL instances:
Server1 <default install running Enterprise>
Server1OFFICESERVER <previously running SQL Express, now upgraded to Enterprise>

After upgrading Server1OFFICESERVER to Enterprise, everything seemed to work fine (i.e. SharePoint works fine). However when I try to connect remotely to Server1OFFICESERVER I can't. I've verified through the SQL Surface configuration tool that remote connections are allowed. I've rebooted the server as well. I've tried connecting remotely using various PCs and various applications (e.g. SQL Server Mgmt Studio, Visual Studio, etc.).

Any other ideas to try?

View 4 Replies View Related

Unable To Debug SQL Server 2005 Stored Procedures From Another Workstation Running Visual Studio 2005

Sep 18, 2006

I'm having some problems debugging SQL Server stored procedures on a SQL Server 2005 server. I have installed Visual Studio 2005 on a workstation running Windows XP, now I'm trying to debug a ASP.Net web application that has some code that executes the stored procedures on a Windows 2003 Server running SQL Server 2005.

I opened VS2005 ... created a connection to the SQL Server 2005 instance ... open the Stored procedure ... right click the stored procedure name and selected Step into Stored Procedure and the following message is displayed:

Unable to start T-SQL debugging.Could not attach to SQL Server process on 'ServerName'.

Any ideas.



Thanks,

View 2 Replies View Related

SQL REMOTELY

Jan 7, 2008

 Sub Page_Load(sender As Object, e As EventArgs)    'declarations    Dim conLath As SqlConnection    Dim cmdLath As SqlCommand    Dim rdrLath As SqlDataReader        conLath = New SqlConnection("server=SERVERNAME;uid=USERNAME;pwd=PASSWORD; " & "database=DATABASE NAME")    conLath.Open    cmdLath = New SqlCommand ( "select * from Emails",conLath)    rdrLath = cmdLath.ExecuteReader()    gridLath.DataSource = rdrLath    gridLath.DataBind()    rdrLath.Close    cmdLath.Dispose()    conLath.Close    End Sub
 
Can i connect to SQL on another server ? Becasue when i am trying to do so , i getting error  ! I can connect to sql on my server but if i want to connect to another server i getting error ... help pleas ?

View 1 Replies View Related

Remotely Configuration Help??

Mar 24, 2003

Hi,

It might be a silly question but really took my head. I have a http server and wanted to install SQL server there, so that my client in US can access it. I just wanna know is there anything specific settings while or after installation I need to do so that they can access it and can configure in their Enterprise Manager.
Is it okay if I simply install SQL SErver 2000 in my http server and give the IP address of the server with the port number so that they can go to Client Network Utility and add my server. Later they can come to Enterprise Manager and connect to that?

Please advice me how it is to be done.

Thanks in advance
Rahul

View 2 Replies View Related

Managing SQL Remotely

Sep 27, 2004

Has anyone experienced any limitaions or concerns for managing SQL 2K remotely using remote desktop, pleased advise.

Thanks

View 1 Replies View Related

How To Set Up Connection To MS SQL Remotely

Jun 27, 2007

If I let the pages (ASP) running on the third party server access my database (MS SQL) remotely, what should I do with my database server? I was told to open a port. If it is true, what is the number of the port I should open?

Thanks in advance

View 2 Replies View Related

How Can I Scedule A Job To Run SP Remotely?

Mar 7, 2008

Hi all SQL experts,

I am scheduling a job which need to run a store procedure on the other server. How can I do that?

Thanks a lot.

View 1 Replies View Related

Connect To CE Remotely

Jun 8, 2007

If I have SQL 2005 Standard installed on a server and I log on locally to that server. Can I connect to other machines through Management Studio-->Object Explorer that have SQLCE installed and manage the CE DB?



I think you can only connect to either local .sdf files or ones located on a device attached by USB to the local machine, but I have had some difficulty finding a definitive statement on that.



Thanks

View 1 Replies View Related

Sharing Remotely

Jul 11, 2006

Can you use SQL Express remotely instead of locally.

I have been told that I might be able to use SQL Express as my network server for sharing files. Is this possible, or do I need a different version of SQL to do this?

I have been reading the VBE forums and from what I gathered was that SQL Express is only for a local table only, is this true?

If not, what is the work around, and how do I go to another pc to find out if it is sharable?

I would hate to get several months in my app design and learn that I was headed in the wrong direction.

Thanks

David

View 8 Replies View Related

Sql Debug Help

Apr 5, 2007

how can it be that
when I do the query

select * from rep where batch=133 it returns 730 and


select* from rep left JOIN Information ON rep.site = Information.Sitecode where batch=133 returns more then 730

I want it to return the same records as the first query but with the additional information from the information table --

what am i doing wrong?

View 3 Replies View Related

T-SQL Debug

Jan 23, 2004

Hello, everyone:

How to debug T-SQL codes? Can QA do that? Are there the special tools?

Thanks.

YTZ

View 1 Replies View Related

Need To Debug SP's....

Jun 14, 2008

Hi,

I need to debug my Store Procedures with diff parameters at regaular intervals which shows me memory usage, CPU usage and other usage.

Is there any way to do this?

-- Regards
Prashant Hirani

View 9 Replies View Related

How Can We Debug An SP

Sep 25, 2006

Is there a way like we do in programming or even bettre. Is there any better practice for this.
Thanks

View 3 Replies View Related

Can U Help Me Debug This!!!!

Aug 23, 2007

to all the experts can u help me about my codes Truncated incorrect DOUBLE value: 'NoOfPositives'
here's my code

select
ref_region.regionName,
ref_facility.facilityName,
ref_facility.adr,
ref_facility.facilityNo,

(select count(*)
from dto_initial_screening
where (dto_initial_screening.facilityNo = ref_facility.facilityNo and
dto_initial_screening.testDt between '2007-01-01' and '2008-01-01')) as 'TotalScreened',

(select count(*)
from dto_initial_screening
where (dto_initial_screening.testResult = 'POS' and
dto_initial_screening.facilityNo = ref_facility.facilityNo and
dto_initial_screening.testDt between '2007-01-01' and '2008-01-01')) as 'NoOfPositives'

from dto_initial_screening
left join ref_facility on dto_initial_screening.facilityNo = ref_facility.facilityNo
left join ref_region on ref_facility.adrRegionCd = ref_region.regionCd

where
('NoOfPositives') < (select Cast(paramVal as UNSIGNED) from ref_param where paramCd = 'minPositives')

View 2 Replies View Related

How To Debug A Sp?

Mar 18, 2008

How to debug a sp in sql server 2005?

View 1 Replies View Related

JIT Debug HELP

Feb 24, 2007

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 HP.CUE.Video.PlaybackControl.UpdateProgressBar()
at HP.CUE.Video.PlaybackControl._ProgressTimer_Tick(Object sender, EventArgs e)
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.Callback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
hpqimzone
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqimzone.exe
----------------------------------------
hpqiface
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqiface/4.0.0.0__a53cf5803f4c3827/hpqiface.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
hpqcc2
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqcc2/3.0.0.0__a53cf5803f4c3827/hpqcc2.dll
----------------------------------------
hpqutils
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqutils/4.0.0.0__a53cf5803f4c3827/hpqutils.dll
----------------------------------------
hpqfmrsc
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqfmrsc/4.0.0.0__a53cf5803f4c3827/hpqfmrsc.dll
----------------------------------------
hpqtray
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqtray/4.0.0.0__a53cf5803f4c3827/hpqtray.dll
----------------------------------------
hpqovskn
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqovskn/3.0.0.0__a53cf5803f4c3827/hpqovskn.dll
----------------------------------------
hpqimvlt
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqimvlt/3.0.0.0__a53cf5803f4c3827/hpqimvlt.dll
----------------------------------------
hpqimgrc
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqimgrc/4.0.0.0__a53cf5803f4c3827/hpqimgrc.dll
----------------------------------------
hpqntrop
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqntrop/4.0.0.0__a53cf5803f4c3827/hpqntrop.dll
----------------------------------------
Interop.hpqcxm08
Assembly Version: 3.0.0.0
Win32 Version: 53.0.13.000
CodeBase: file:///c:/windows/assembly/gac/interop.hpqcxm08/3.0.0.0__a53cf5803f4c3827/interop.hpqcxm08.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
LEAD
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead/13.0.0.113__9cf889f53ea9b907/lead.dll
----------------------------------------
LEAD.Wrapper
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.wrapper/13.0.0.113__9cf889f53ea9b907/lead.wrapper.dll
----------------------------------------
LEAD.Windows.Forms
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.dll
----------------------------------------
LEAD.Drawing
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.drawing/13.0.0.113__9cf889f53ea9b907/lead.drawing.dll
----------------------------------------
interop.hpqimgr
Assembly Version: 3.0.0.0
Win32 Version: 53.0.13.000
CodeBase: file:///c:/windows/assembly/gac/interop.hpqimgr/3.0.0.0__a53cf5803f4c3827/interop.hpqimgr.dll
----------------------------------------
hpqthumb
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqthumb/3.0.0.0__a53cf5803f4c3827/hpqthumb.dll
----------------------------------------
hpqasset
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqasset/4.0.0.0__a53cf5803f4c3827/hpqasset.dll
----------------------------------------
hpqmirsc
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///C:/Program%20Files/HP/Digital%20Imaging/bin/hpqmirsc.DLL
----------------------------------------
hpqedit
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqedit/3.0.0.0__a53cf5803f4c3827/hpqedit.dll
----------------------------------------
hpqvideo
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqvideo/3.0.0.0__a53cf5803f4c3827/hpqvideo.dll
----------------------------------------
LEAD.Windows.Forms.DrawingContainer
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.windows.forms.drawingcontainer/13.0.0.113__9cf889f53ea9b907/lead.windows.forms.drawingcontainer.dll
----------------------------------------
hpqmdmr
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqmdmr/4.0.0.0__a53cf5803f4c3827/hpqmdmr.dll
----------------------------------------
LEAD.Drawing.Imaging.ImageProcessing
Assembly Version: 13.0.0.113
Win32 Version: 13.0.0.113
CodeBase: file:///c:/windows/assembly/gac/lead.drawing.imaging.imageprocessing/13.0.0.113__9cf889f53ea9b907/lead.drawing.imaging.imageprocessing.dll
----------------------------------------
hpqimlib
Assembly Version: 3.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqimlib/3.0.0.0__a53cf5803f4c3827/hpqimlib.dll
----------------------------------------
hpqglutl
Assembly Version: 4.0.0.0
Win32 Version: 053.000.013.000
CodeBase: file:///c:/windows/assembly/gac/hpqglutl/4.0.0.0__a53cf5803f4c3827/hpqglutl.dll
----------------------------------------
Interop.hpqvideo
Assembly Version: 3.0.0.0
Win32 Version: 53.0.13.000
CodeBase: file:///c:/windows/assembly/gac/interop.hpqvideo/3.0.0.0__a53cf5803f4c3827/interop.hpqvideo.dll
----------------------------------------

************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (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:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

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


View 2 Replies View Related

Debug

Jan 18, 2006



Hello guys!
I am trying to debug a sql procedure inside Server Explorer but I can seem to step into each line.
When I run the procedure it doesn't stop in the breakpoint I set.

By the way I am running in a client pc..

Please help guys!

View 12 Replies View Related

Managing SQL Server Remotely

Jun 26, 2007

I've combed through SQL Help to find the answer to my question but I think it's telling me it can't be done. I work both from an office with my servers and from home. When I'm at home I would like to access my SQL server remotely using a tool such as MS SQL Server Management Studio. But it appears there is no way to access my SQL Server for management purposes using Management Studio over a remote internet connection. I can access the server using Management Studio while I'm on the internal office network but not from home.
Has anyone been able to do this or might recommend a third party tool as robust as Management Studio?
Thanks 
 

View 6 Replies View Related

Remotely Connect To MSDE

Dec 29, 2003

Hi
I just installed MSDE over my Windows 2003 box and facing an small problem.
I installed it with SQL security mode and also set a password for user "sa".
Everything looks just fine using "osql" as it uses local address.
But I can't connect to my server from another computer using VS.NET Server Explorer.
It seems as MSDE is set to reject connections from outside by default.
My question is how to enable it so I can connect using my "sa" account.
Appreciate your help in advance.

View 3 Replies View Related

Can't Connect Remotely To SQL Server

Dec 30, 2005

I just reinstalled SQL Server and after reattaching my databases, I can't connect remotely. If I use "localhost" in my connection string it works fine, but I can't register my remote Enterprise Manager this way.

View 1 Replies View Related

Register SQL Server Remotely

May 17, 2002

Hi all,

Can someone tell me if it is possible to register and connect to a SQL server that is not on my local network? I want to be able to use the Enterprise Manager to make updates to the SQL servers in my office from home. I am using SQL 7.0

Thanks in advance,
Chris

View 1 Replies View Related

New To SQL - How Can I Administer SQL Server Remotely?

Nov 30, 1999

I'm trying to configure my workstation so that i can connect to the SQL server over the internet.

I've tried using the network connection utility and enterprise manager but am not having much luck = P

Any advice would be greatly appreciated.

Thanks!

View 1 Replies View Related

Best Way To Remotely Admin Sql 2000

Aug 7, 2003

Will start supporting mission critical application soon and looking a best way to remotely support it, short of dragging a laptop with me everywhere. Was going to eval PocketDBA. ANy other ideas/solutions?

View 5 Replies View Related

SQLServer Could Not Be Stopped Remotely

Aug 29, 2000

I tried to stop SQLServer romotely through Enterprice Manager. It used to work. But, this time I got a message "a error 5 - (Access is denied) occurred while perfrming this service oetation on the MSSQLServer service." and it could not be stopped.

Do you know why and how to stop it.

Thank you ahead of time

View 1 Replies View Related

Remotely Accessing Database

Oct 15, 2004

I'm developing a VB app to manipulate data in a table. I've created an SQL server (local) and have successfully connected to and manipulated data in a database that I created. I would like to be able to run the app on another machine and connect to the same server. I'm having trouble determining what the server name is. Tried a few things but get the "server does not exist" message. Server is set to authenticate SQL server and windows.

Is this happening because my server is (local)? If so how do I change it to permit remote access?

Any assistance would be appreciated.

View 2 Replies View Related

Using Osql To Run A Sql Script Remotely

Jan 15, 2005

I'm attemping to run an sql script remotely by using osql. It works in a test environment (remotely) but when I attempt it on our production server (remotely), it fails.

Alternatively, if I run osql in the production server (locally), the script executes fine.

Should I be doing this via a different method or are there some security settings preventing me from using osql remotely in my production environment?

Thanks for any help,
Zac

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved