Can Not Connect To Desktop DB

Jun 28, 2001

My organization supports both SQL 7 and SQL 2K. Therefore I have the Enterprise Manager
for SQL 2K on my desktop (it accesses both SQL 7 & SQL 2K, but the SQL 7 EM won't access
both).

I installed the SQL 7 desktop edition on my NT 4 (SP 6) workstation, but only the server (not
client connectivity or client tools).

When I attempt to perform a new server registration using EM (with the desktop server running),
I get the following message:

"SQL Server does not exist or access is denied"

I am attempting to logon as "sa" with a blank password since this will be my very first access of
the installed DB.

Startup of server specifies that the "local system" account be used. Server starts up fine as best
as I can tell.

For client connectivity I have both TCP and NAMED PIPES available.

Any help would be very much appreciated!!!!

Thanks Gary Andrews
andrews_gary_w@solarturbines.com
P.S.
Where blank passwords are used, do I enter a single space or not enter anything
and just press enter?

View 4 Replies


ADVERTISEMENT

Connect To Desktop Database 2

Jan 24, 2007

Please Help me!

I hav emulator Windows CE 4.0 with Visual Studio 2003, C#.

I want connect to sql server 2000......after read all posts of this subject and try all varieties modes of connecting string.....in sql profile i see that application in emulator try to connect the sql server but i have the same exception :

PlatformNotSupportedException

Here my code:

strcon = "Server = developer\devsql;Initial Catalog = master;User ID = domain\login; password = ******;Integrated Security = false";

What i did wrong or may be miss something?

View 1 Replies View Related

Connect To Sql Server Desktop Engine Over Internet

Apr 11, 2004

i have got to connect to sql server desktop engine over internet with the following connection string

conString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=" & dbName & ";Network Address=" & IPAddress & ";Data Source=" & DataSource & " ;User ID=" & UserId & " ; Password=" & Password

Plz also inform me about the restriction imposed in connectivity by any of the window operating system such as that win 98 wont work or work!

There is no firewall involved. The two computers are in the same room and connected directly to the internet.

Even the ping is not going to either computer.

So what could be the possible problem and the solution.

need urgent

View 1 Replies View Related

VS 2005 - VB.NET - Connect To Mobile SQL Database From Desktop PC

Jun 7, 2006

I want to physically move my .SDF file to my desktop and then access this file from VS 2005 VB.NET. Ideally, I would want to access this .SDF file from MS Access 2003 but I undersand this is not possible.

Here are my VS 2005 VB.NET statements....

Dim ConnPPC As New System.Data.SqlClient.SqlConnection("Data Source = C:Documents and SettingsG014436My DocumentsSQL

MobileActMgr6CE.sdf")

Dim mySqlDataAdapter2 As New SqlDataAdapter("select * from T0002_AE_Activity_Entry", ConnPPC)

mySqlDataAdapter2.Fill(myDataSet2)

On executing the last statement(fill)...I get the following error.

function failed: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Does anyone have any suggestions?

View 6 Replies View Related

Can Not Connect To Desktop Sql Database From Mobile Device (Pocket PC)

Apr 4, 2006

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.



Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System



Public Class Form1

Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."



ReadOrderData()

End Sub



Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

View 15 Replies View Related

Newbie Trying To Connect To Adventure Works Db On Local Desktop

Jan 22, 2007

All,

I'm running Windows Xp Pro With SQL 2005 Dev edition with Adventure Works sample db installed. I am the local administrator on my desktop, the services are up and running and I specified local connections only since this is the DEV edition of SQL05.

When I try either one of these connection strings: Data source=(SQLDEV05); initial catalog=AdventureWorks or Data source=(local); initial catalog=AdventureWorks.

I receive this error message:



TITLE: Microsoft Report Designer
-----------------------------

A connection cannot be made to the database.
Set and test the connection string.

----------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

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

================================

Thanks in advance!

>Scott

View 3 Replies View Related

Unable To Connect To SSIS Or SSRS On SQL Server 2005 Standard Edition Server Via Desktop Connection

Mar 8, 2008

Hi,

I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.

SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.

So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.


However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.

I am using Windows Authentication where the I used a SQL Server account which exists with €śsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.

What do I do next please?

View 4 Replies View Related

SQL Desktop And C#

Sep 2, 2005

Hello, i'm trying to make a c# web form in vs.net 2003 and a connection to a sql database.I'm using a sqlconnection control and a sqlcommand, but when i test it, the page said: "There was an error in login Encuesta, with the user LOCALHOST/ASPNET" (or something like that)i don't have the source code, and i am not in my pc, so, can somebody help me?

View 5 Replies View Related

OLE DB On Desktop

Feb 28, 2007

hello everybody,

I've installed SQL Compact Edition (with Visual Studio 2005) and i try to compile Northwindoledb for the DeskTop. The goal of this operation is to migrate a Pocket PC application (C++/OLE DB/SQL Mobile) to the desktop. If i can run properly Northwindoledb project i could start to migrate ...

I've the following error :

hr = pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL);

GUID_NULL undefined

What can i do ?

Thanks in advance !

View 1 Replies View Related

Desktop Server

Feb 24, 2007

1. Today I've installed webmatrix and MSDE200A and followed this instruction"Select 'SQL2kdesksp3.exe' and save it to your computer.Double-click on the SQL2kdesksp3.exe you downloaded.Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt.Start > Run > cmdNavigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.The default is C:sql2ksp3Type Setup SAPWD=(Some password) SecurityMode=SQLExample:c:sql2ksp3> Setup SAPWD=password SecurityMode=SQLAfter that gets done running, MSDE is installed.Start servicesTo get the SQL Server running and the SQL Agent we need start the services.right click My Computer > manage > servicesDouble click the following and set to Automatic.MSSQLSERVERSQLSERVERAGENTMake sure both are on automatic." then I restarted my comp. I've tried to connect to database but it did not work.I need the reply ASAP!!!!   2.What are the different among  MSDE200A.exe, sql2ksp3.exe, and sql2kdesksp3.exe ?

View 1 Replies View Related

SQL Desktop License?

May 29, 2001

If I just need a desktop version of SQL 7.0 installed for local development. (Not being used as a server) Do I just need a CAL license?

Thanks!

View 3 Replies View Related

Desktop SQL Server 7

Dec 7, 1999

Is it necessary to have a MS Loopback Adaptor to install SQL Server desptop edition at my home ? ( Otherwise i am unable to connect to the server from the EM )
Thanks,
Deepak.

View 1 Replies View Related

Installing Sql 7.0 Desktop

Jul 26, 1999

I have installed Sql 7.0 desktop edition on Win 98 with IE5 and am having a problem starting the Sql server.
It auto registered the server under my machine name. It was returning a network connection error so I deleted it and tried to add one with the name (local). Enterprise Manager then returned an error saying one was already registered under that name.

Anyideas?

Thanks

JC

View 1 Replies View Related

Sql2005 For Desktop

Jun 1, 2007

Hi All.
I have SQL2000 on my WinXP computer. Can I install SQL2005 on my desktop? If yes what version?
Thanks.

View 1 Replies View Related

SQL 2000 Desktop

Jul 20, 2005

Is it possible to install SQL 2000 desktop without installing a databaseserver? I need to have the interface to access my database servers, butdon't want the overhead of a server and the service on my laptop.Possible?ThanksDoug

View 2 Replies View Related

SDF Creation On Desktop

Jun 6, 2005

Hello,

View 21 Replies View Related

Creating SDF On Desktop

Jan 2, 2007

I have read all posts in this forum, but the answers for the main questions are still not completely clear for me. My scenario is smilar than other described cases.

I would like to send a large amount of data to a Windows CE device which runs SQL Server Mobile Edition 2005. Replication is not possible, cause the desktop size of software sometimes uses Oracle or earlier versions of MSSQL Server (for e.g. MSSQL 7.0).

For syncrhonizing data we have two possibilities:

1. sending the data in some format (csv, xml, etc...) to the Windows CE device, parse this file and insert the data into a database, the speed of this is unacceptable, so if it is possible I wouldn't like to use this method

2. Create the SDF file on desktop side, it would be very fast, because it makes unnecessary the post processing on a slow Windows CE device. So please give me a short (YES / NO is completely enough) answer to this: is there any *LEGAL* way to create an SDF file for SQL Server Mobile Edition without buying VS2005 or MSSQL2005 licenses for the desktop computer?

Thx for any help in advance. If the question was answered clear earlier, sorry for wasting time. I think a lot of us struggling with this problem.

View 5 Replies View Related

Creating A CE Db At The Desktop PC

Dec 13, 2006

Hello,

Is it possible to create a .SDF file at the develop machine?I want to write an exe which creates a sdf.So, my customer will be able to create a sdf and import this sdf to the device.



Thanks.

View 1 Replies View Related

BETWEEN LAPTOP AND DESKTOP

Sep 27, 2006

Hi,

I want to jumpstart my learning of SQL Server so I downloaded the Express edition onto my desktop in the office and also onto my laptop. I usually connect the two machines (through a LAN) to update whatever I was able to do at home while in the office.

What should I do in order to view or edit whatever I started on the laptop from the desktop? Would the databases I create on one be accessible through the other machine for editing and the likes?

Glint.

View 3 Replies View Related

SQL CE Desktop And PDA Sync

Apr 16, 2008


I have a very simple application that is desktop and windows mobile. I am just starting work on it so the options are wide open for now. My goal is a simple database that will sync columns on both sides.

The SQL Compact Edition database seems like the perfect database to use for this application.

The only way I currently know of to sync a PDA database to the desktop, however, is to use IIS and SQL server on the desktop side and then use the ADO.NET sync stuff.

I don't want to have to set up IIS and SQL server on my client's computers. It will be a mass market product and that is just inviting a ton of support that I don't want to have to deal with. The application is too simple and cheap for that.

I know I can go the old fasion ActiveSync component route, but that is such a pain. I could also use a 3rd party solution, but again, too expensive for this application.

My question is whether anyone knows of a simple solution.

Is there any way in SQLCE to query a remote database and do updates to it? Could the desktop application get access to the PDA SQLCE database or the other way around?

Any help would be great. I have the experience to write an ActiveSync component myself. That is not the problem. It is just such a pain and it seems like in today's day and age I shouldn't have to.

View 8 Replies View Related

Upgrading SDF 2.0 To 3.1 On Desktop

Feb 28, 2008



Hello,

Everybody knows that Upgrade.exe is not a win32 application.

Since it is now possible to connect SQL CE 3.1 database with Framework 2.0 and SQL CE 3.1, I am wondering if someone is aware of a method to convert SQL CE 2.0 database to SQL CE 3.0 with Desktop Framework ?

(--> I have a lot of SQL CE 2.0 databases where I would like to connect avoiding use of a PDA. In order to do that, I need to convert all of them)

Thanks

Adrien

View 1 Replies View Related

Sql Server Desktop Edition

Dec 19, 2003

hi, can I use sql server desktop edition to deploy my web application and at the same time I am not violating license agreement with Ms.

thanks
Al

View 1 Replies View Related

Sql 2000-Desktop Edition

Feb 8, 2002

I want to know if there is Desktop edition for SQL 2000 Server and if so does it comes bundled on the same CD like it did for MSS 7.0.Also is there a limit to the size of DB's that can be build with it.
Thanks a Bunch

View 1 Replies View Related

Sqlagent Start On W98 Desktop

Oct 11, 2000

how can i start automatically sqlagent if it doesn't on W98 ?

thanks for answer

View 2 Replies View Related

SQL 7 Desktop Edition Licence

Sep 20, 2000

What type of licence do I need to run Desktop Edition of SQL 7.0. Is there such a thing as desktop license.
How much Does it approximately cost.
Thanks

View 3 Replies View Related

Upgrade From Sql 7 To Sql 2000 On My Desktop

Apr 18, 2003

Hi all:-

How do I upgrade my local sql server 7 to sql 2000 ? Do I just put in the sql server 2000 CD and run it or is there an upgrade CD ? I have lots of stuff on my sql 7 and don't want to lose it.

Thanks in advance!

View 1 Replies View Related

Sql Server Desktop Edition

Feb 2, 2005

my application has a good amount of data that is specific to each company (where there is only one user). i am currently setting it up as a access project, but was wondering about another route. to store the local data would there be an advantage to setting it up as a access project, and use the sql server desktop engine for the data, or should i stick with mdb tables?

View 2 Replies View Related

NT Authentication - Remote Desktop

Jun 23, 2006

I connect to a compute via Remote Desktop Connection that is running SQL Server 2003. That part works. However, once I'm connected, and running SQL Server, I cannot see my user name in SQL, when I use the query, "SELECT user_name as ()". What I see instead is "DBO". Nor does it show me as being in a particlar group. I also cannot see my Windows Authentication remote computer name.

I think it has something to do with using my PC to do the Remote Desktop Connection and then from there, running SQL Server 2003, but am lost on this one.

Can anyone help? I sure would appreciate it! Thanks in advance!

*********************************************************************
This forum is best viewed with a computer. Questions asked freely. Confusion happily shared.

View 5 Replies View Related

How Is The SQL2000 Desktop Licensed?

Jul 20, 2005

Could the SQL2000 Desktop Engine be bought individually or they onehave to buy the Enerprise version in order to get the Desktop Engine?All we need right now is the Desktop Engine.Thank you very muchmike

View 2 Replies View Related

Edit Sdf Database On Desktop From Pda

Mar 27, 2008

Hi, I would create a vb2005 application that allow me to edit a sdf database stored into a pda connected at pc with activesyn directly on my desktop as well as "SQLCE Database View".
How can i do it??


Please help me

View 1 Replies View Related

Sync Between Mobile And Desktop

Oct 6, 2007

Can I synch between a Mobile device using SqlServer Compact and desktop PC running Sql Server Express using Microsoft Synchronization Services?

View 1 Replies View Related

Read SDF File In Desktop

Jan 23, 2007

Dear all,

  I Need to read the Data from the SDF file in the Desktop. I have SQL Server 2005 in my System.

i know this is possible. but i dont know how it is ....  

 

regards,

Tamil

View 4 Replies View Related

View/Edit SDF On Desktop

Jun 12, 2007

I inherited a WinCE.net application that uses SQL Server CE as the database. We use Visual Studio 2003 to write the program. Using the query analyzer on the device is difficult and I would much prefer to do my database views/research on my desktop. I could even copy the SDF over to the desktop, slice and dice it and then return it to the compact unit. But what do I need to have on my desktop so I can view these SDF files? Thanks.

View 10 Replies View Related







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