Problem In Connecting To MSDE Database From The Same Domain

Dec 13, 2005

Hi!
I have installed MSDE 2000 in "Mixed Windows and SQL mode authentication with network access" .following is the command:

setup.exe DISABLENETWORKPROTOCOLS=0 SAPWD="password" INSTANCENAME="TempInstance" SECURITYMODE=SQL

Then I created the database TempDB in it.

When I try to connect this database from my program running on my machine , it works fine. But when i try to connect to it from the same program running on a different machine on the same domain.It gives error:

"SQL Server does not exist or access denied ."

Even when i run the same program in my machine to access the same TempDB database on a remote machine that is not in my domain, it works fine.

this is my connection string:
Data Source={Database server's IP Address}TempInstance;Initial Catalog=TempDB;User ID=sa;PWD=password;

Please help.

KT.

View 2 Replies


ADVERTISEMENT

Msde - Connecting To The Database

Jan 3, 2004

Hi,

I have installed MSDE into my system, in which SQL Server is not installed. I have followed the installation instructions and installed MSDE.
How can i connect to the database? I have the .MDF file of the database (already created in sqlserver) in the Data Folder. How can i connect to the database from Visual Basic 6?

View 1 Replies View Related

MSDE 2000 On A Domain Controller

Apr 18, 2007

Hello everyone, I have searched the forum regarding this topic and have found numerous good threads about installing SQL Express on a DC. My question is, I am assuming that if installing SQL Express on a Domain Controller is not recommended, that installing the MSDE 2000 on a Domain Controller is not recommended either?



Thanks in advance to all replies!


Tim

View 3 Replies View Related

Connecting To SQL Server Of Another Domain

Aug 27, 2007

Please help me to find the solution for following problem.
I have my web server (with .NET 2.0 Framework) in one Domain(DMS01) where i have deployed my application (developed in ASP.NET 2.0). I have to access the database (SQL Server 2000) that belongs to another Domain(DMS02). How could i connect to the database that belongs to domain DMS02 from Web Application belonging to domain DMS01.
Thanks in advanced for help.
 
 

View 5 Replies View Related

Moving A DB To A Different Domain And Then Connecting

Oct 9, 2006

If a thief yanks (technical term) a hard-drive containing a SQL Server 05 database from a server and then installs it on a server in a different domain, is there any way he could connect to it? This question assumes that a hacker didn't somehow transfer the domain logins.

Could the local admin even add himself as a user to the database without having the admin login information from the previous domain?

Thanks,

View 1 Replies View Related

Connecting SQL Server 2000 From Different Domain.

Apr 24, 2007

Please help to connect SQL server 2000 on different domain.
Please correct if I m wrong.

System details as follows

Client
Domain : DomainA
System : System1
IP Address : 10.10.225.19
SQL server 2000 installed


SQL Server
Domain : DomainB
System : System2
IP Address : 10.108.22.19
SQl Server : System2inst2 ( My database is under inst2 instance)
SQL login : TestUser1
Password : Users123


I have Opened firewall port to access 10.108.22.19 from 10.10.225.19

While connecting the SQL server €śSystem2inst2€? from the client machine enterprise manager with the SQL authentication, I am getting error Login failed for user €śTestUser1€?

And I have noticed in the SQL server log the login attempt shows under System2 default instance ( no instance). Actually I want to connect system2inst2.

Please let me know the steps to connect.

Thanks in advance.

View 3 Replies View Related

Connecting To Sql Server (within Windows Domain) Through Linux?

Jul 20, 2005

Hi,I'm planning to develop a small intranet to provide our organizationwith documents online. I've decided to do this using jsp/servletsusing a tomcat server. For an operating system, I have chosen red hatlinux. However, I'd like to keep a small database on a sql server asa datasource. However, this sql server is already part of ourorganization's windows domain. I suspect I'll need to configure sambaso that other terminals on the windows domain will be able to reachthe intranet. What's the best manner in which to connect my linuxservlets to this sql server database? I suspect this may bedifficult, considering the sql server exists within a windows domain,but as a beginner, what do I know. Perhaps someone could point me inthe right direction.

View 4 Replies View Related

Domain User Privilege For Connecting SQL Server 2000

Mar 30, 2006

Hi,

My server administrator has created a few users as domain user privilege for connecting SQL server from my application. However it faild to connect, and

with Domain Admin privilege, my app is running ok.

I asked admin person to upgrade domain user privilege to connect SQL server,

but he couldn't do this for security reason, and told it should work with domain user.

Is it true for domain user to connect SQL server without any problem?

Do I need to add the user, domain user, into Logins of Security inside SQL server Enterprise Manager?

Or inside users of my database section of SQL server EManager?



Thanks,

dixon



View 1 Replies View Related

Connecting (ODBC) To SQL 2005 Express From Different Domain With Trust

Aug 23, 2007



Hi!
I am trying to establish connection from different domain using ODBC driver with no luck!
I am able to do it within my domain from any place, but it fails from outside. I have two-ways trust established between domains. Users are able to see and use resources both ways.
When I create ODBC it doesn't matter if I use SQL or Windows NT authenctication, I am getting error:

Connection Failed:
SQLState: '01000'
SQLServer Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (getbyhostname()() )
Connectio Failed:
SQLState: '08001'
SQL Server Error: 11


I tried to set it with TCP Static Port or Dynamic. No difference.
What should I look into?

Any ideas? Any help?

Thanks.

View 7 Replies View Related

ASP.NET Connecting To MSDE

Aug 24, 2004

G'day,
I'm very new to ASP.NET (but not to programming) and I'm having some trouble with connecting to a database.

I am using C#.NET and I dragged the SqlConnection component onto the form, set the connection string to (local) and to use integrated security, and on that data link properties page I can press the test connection and it works fine, and I can see the databases in "select database on server" drop down box... but when I try and Open() the connection I get a

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'AMD2500ASPNET'.

Can anyone help me?

Thanks,
Robbo

View 1 Replies View Related

Connecting To MSDE

Nov 1, 2005

I am trying to connect to a MSDE database on server from my desktop using query analyzer. I keep getting the generic "SQL Server does not exist or access denied'

I have verified the following:
- the login/password is valid because when I access osql from server I can gain access
- the registry for Loginmode appears OK - set to 2 - mixed mode

What else do I need to check...

Thanks, kgaske

View 4 Replies View Related

Connecting To MSDE

Jul 23, 2005

Being new to the SQL server world I have a beginner question.How do I grant access to database from a networked computer?I have tried:sp_grantlogin '\computernameusername'and I get the error:Windows NT or user <above> not found. Please check name.Any help would be appreciated.ThanksEric

View 1 Replies View Related

Connecting To MSDE Using SSPI

Feb 14, 2004

Please advise: I have created a simple ASPX page to test if I can connect to MSDE on a Server 2003 system. The connection string that works ok is:

server=WS1;database=northwind;integrated security=false;user id=sa;password=xxx;

but the string that does not work is:

server=WS1;database=northwind;integrated security=SSPI;

which is the string I would like to use for normal web access. This string works fine on my development system (where I use XP Pro and IIS 5.1)

In IIS6 on the "production server" the directory security on the virtual dir is set to allow anonymous access, using user IUSR_WS1 (where WS1 is the name of the system) and to integrated security.

Please help! Thank you

John B

View 7 Replies View Related

Problem Connecting To MSDE

Aug 10, 2005

I just installed MSDE and when I try to connect to it I get the following message:"Uable to connect to the database. General network error.  Check your network documentation.ConnectionRead (recv()).TDS buffer length too largeTDS buffer length too large"Can anyone tell me how to correct this problem?

View 1 Replies View Related

Problems Connecting To MSDE Through ADO.NET

Sep 27, 2005

Hi there, i've installed MSDE and have successfully connected to it from a remote version of Enterprise Manager but when i try to connect using ADO.NET from a website using the same login details i get the following message:"SQL Server does not exist or access denied"I installed msde with DISABLENETWORKPROTOCOLS=0 and SECURITYMODE=SQL so everything should be setup properly. My connection string looks like this:server=ip_addressinstance_name;uid=myusername;pwd=mypassword;database=mydatabaseThis connection string works fine when testing locally (without ip address ie. localhostinstance_name)Any ideas why this doesn't work??

View 2 Replies View Related

Connecting To SQL Or MSDE Difficulty !!

Oct 28, 2005

Hey guys,     I am a newbie here, so please bear with me. I have installed SQL Server 2005 CTP on Machine A and MSDE on Machine B. Both these contain the PUBS database beside others. On Machine C, I have installed "ASP.Net Web Matrix" and I want to be able to connect to either Machine A or B to access the PUBS database. It connects to Machine B, when I put in the Servers IP address. But everytime I try to connect to Machine A, it gives me an error saying, "Unable to connect to the database. To connect to this server you must use SQL Server Management Studio or SQL Server Management objects(SMO) ".    I heard that connection strings are needed to access the SQL Server 2005 but I have no idea where to begin. Do I need to create special users to access the Server or will Windows authentication work ? Could anyone help me out in connecting to the SQL Server 2005 CTP?

View 15 Replies View Related

WebMatrix And MSDE Connecting Problem

Nov 8, 2003

Hello,

I have downloaded WebMatrix/NET.Framework and it works well.
Unfortunatelly I have problem with connecting to MSDE.
I've installed the new version (sql2ksp3a) like they say:

setup.exe INSTANCENAME=my_inst_name DISABLENETWORKPROTOCOLS=0 SAPWD=my_pass
SECURITYMODE=SQL

The MSDE works ok (I can connect from a commercial programs - for example
'MSDE Manager') and seems to be ok.
But when I try to connect from Web Matrix I get the error:
"Unable to connect to database, Invalid connection connection Open, Invalid
instancename".

I put all the parameters correct:
user: sa, auth.type: SQL, server: my_pc_namemy_instance_name

By the way the instance name and my PC name is the same. Could it be the
reason ?

Please help,
greetings to all

View 1 Replies View Related

Connecting To MSDE W/read Only File?

Jul 23, 2005

Hi,Does anyone know how I can connect to an MSDE db using VB with aread-only file? The file will be on a CD, and is actually just archiveddata off a SQL server. I would like to package my app on a CD alongwith the data file and allow users to pop in the CD and run the app,assuming they already have MSDE running. Any help?Thanks,Jason

View 1 Replies View Related

Problem In Connecting To MSDE 2000

Feb 28, 2008



Hi,

I have installed MSDE 2000 and when i am trying to connect to the server from command line using following command -

osql -U sa

It gives error message -

Login failed for user 'sa'
The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.52


Please advise.


Thanks
Abhijeet

View 5 Replies View Related

Connecting To MSDE 2000 Over A Home Network

Dec 28, 2005

Hi,

I'm trying to connect to an instance of MSDE 2000 from Visual Studio 2005 over a home network.  Although I know how to connect to a database from Visual Studio, I'm pretty clueless about configuring Sql Server to allow the connection (I can connect with no problem when I do so from the same computer).  Also, with experimenting I've created a bunch of instances of Sql Server that I don't really need and am not sure how to get rid of them.  Thanks in advance for any help.

-Dave

I don't know if this will help, but I've already tried enabling all of the network protocols in the instance.  Also, I can easily connect to an Access database over the network.

View 1 Replies View Related

SQL Security :: Log Ship Database In Server Instance In One Domain To Database

Jul 2, 2015

I had created 2 Sql server instance in 2 servers created using VMware. From the primary server I log shipped the required databases into the secondary. Both the servers were in the same domain whose active directory was also in another server in the same virtual lab environment. My question can we have the primary sql server in one domain and the secondary sql server to which the logs are shipped in another domain by including a router also between the 2 networks for connectivity?

View 6 Replies View Related

User On Trusted Domain Does Have Permission To Access Linked Server On AD Deployed In Another Domain

Sep 28, 2007

Hi,
We have the followoing:

-A "master domain" AD, a "sub domain" AD, a trust relationship between the two (sub trust master)
-A sql server 2005 on a win server 2003 in "sub domain" AD
-A linked server to "sub domain" AD
-A linked server login using a "sub domain" admin acccount
-A view to this linked server
-A grant on masterDomain/Domain Users to the database
-A grant on subDomain/Domain Users to the database
-We want all connections done through "Windows Authentication" not "Database Authentication".

Queries on the view work fine using "sub domain" user accounts.
Queries on the view fail using "master domain" user accounts (including master domain admin accounts)


"Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation."

All connections are done through "Windows Authentication" not "Database Authentication".

Can we establish cross domain connectivity with "Windows Authentication" ?


Below are details of the implementation:

SELECT TOP (100) PERCENT *
FROM OPENQUERY(ADSI,
'SELECT displayname, givenName, sn, cn (etc...)
FROM ''LDAP://OU=PEOPLE,DC=subDomain,DC=com''
WHERE objectCategory = ''Person'' AND objectClass = ''user'' ')

EXEC sp_addlinkedsrvlogin @rmtsrvname ='ADSI', @useself='false',
@rmtuser='subDomainAdminAccnt', @rmtpassword='sunDomainAdminAccntPassword';

In SQL Server Mngt Studio in Server Objects/Linked Servers/Providers/ ADSI properties security tab I have:

"connections will: <be made using this security context> Remote login:'subDomainAdminAccnt' With password: 'subDomainAdminAccntPassword'

Error:
Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation.

Msg 7320, Level 16, State 2, Line 1

Cannot execute the query "SELECT displayname, givenName, sn, cn

FROM 'LDAP://OU=PEOPLE,DC=subDomain,DC=com'

WHERE

objectCategory = 'Person'

AND objectClass = 'user'

" against OLE DB provider "ADsDSOObject" for linked server "ADSI".

View 7 Replies View Related

Problems With Change Sql Permissions After Migrating Domain User/group Accounts Into Root Domain

Apr 5, 2007

I have a root domain and child domain.



After using ADMT to migrate the domain user or group into the root domain, when I use enterprise manager to try and change the permissions allocated to that domain user/group, i get the 'Error 15401 NT user or Group not found'.



This is a correct error as the user is now in the root domain, however sql (in sysxlogins) still thinks its in the child domain.



Is there a simpler way, other than collecting the users permissions, deleting the user from SQL then adding back in with the correct domainusername format, then adding the permissions back?



I tried renaming the 'name' in sysxlogins (not recommended) and while that worked, whenever I tried to add the migrated user to another database, the login name was missing and would not resolve.



I believe it is something to do with the SID not matching.



Any ideas on how to fix this ?

View 1 Replies View Related

SQL Security :: Domain Migration Altered SA Or Domain Admin Access To DBs

Jun 19, 2015

we recently migrated from our in-house domain to the Enterprise domain. Everything went smooth except for the fact that I can no longer accept my dBs using my SA or my domain admin account. There is only 1 account I can get into the management studio with but it has no admin privileges, so I can't make any  password changes or add accounts. I don't have a test environment so kind of hesitant to experiment with our production system.

View 6 Replies View Related

Configuring Database After Domain Rename

Nov 20, 2007

I didn't know exactly which forum to post this in, so if I need to post it into another one, please let me know. Also, I have absolutely no SQL or DB experience. I am learning as I go.

The Situation:
I created a virtual network for my company which included MS CRM, which uses SQL Server 2005. Everything was working fine until today. My company asked me to make a change to the domain name, as we are changing company names. I followed the processes through microsoft's documentation that I found online. The rename went fine. Since then, we can no longer access CRM. When I run the environment checks, it gets hung up on the SQL Server components. It says that it can't confirm the MSSQLSERVER service is running (it is) and it can't connect to the database. As best as I can tell, the database is looking for the old domain name, which doesn't exist. How do I edit or configure the existing database to reflect the new domain name. It's important to do this as we have data in that database that we need to access. Any help in this matter is very much appreciated!!!

View 4 Replies View Related

Restore Database On Different Domain - Performance

Oct 2, 2006

Hi,

I'm trying to restore database on the server in the different domain.

The destination server is located in the physically remoted place.

First I tried UNC path (including IP address) with DBCC TRACEON | OFF (1807) optioin but it didn't work.

Some Internet document suggested that the FTP file transfer & restore locally on the remote domain but I didn't use this method because there is additional step.

Instead I used the following scripts:

DECLARE @COMMANDLINE VARCHAR(500)

SET @COMMANDLINE = 'NET USE B: \192.168.1.xxxsql_backup$ password /USER:SourceServer
ead_sql_backup /YES'
EXEC master..xp_cmdshell @COMMANDLINE

RESTORE DATABASE [DestinationDB]

FROM DISK = N'B:SourceBackup.bak' WITH
FILE = 1, NOUNLOAD , STATS = 10, REPLACE ,
MOVE N'dMSLog' TO N'D:MSSQLDataDatabase.ldf',
MOVE N'dMSData' TO N'D:MSSQLDataDatabase.mdf'

SET @COMMANDLINE = 'NET USE B: /DELETE /YES'
EXEC master..xp_cmdshell @COMMANDLINE

The script is working but it's extremly slow.

The size of database is only 1152.88 MB but it took more than 2 hours.

Is there any way that I can improve the performance?

Any advice would be appreciated

Thanks,

- Hyung -

View 2 Replies View Related

Create A Database Login In The Default Domain

Jul 23, 2005

I'm trying to create a login in the default domain. I know I can pullthis information from xp_loginconfig, but don't see how I can use it inthe context of sp_grantlogin.For example, pull the domain the user is currently logged in on andinsert it into the sp_grantlogin script. Has anyone ever done this inthe past?

View 2 Replies View Related

Transact SQL :: Query From Database From A Different Server And Domain

May 7, 2015

In my procedure I need to pull data from a database which is on other server and domain.

As usual I have used the below query but having troubles with mode of authentication.

SELECT * FROM OPENROWSET('SQLNCLI', 'Server=x.x.x.xsyz;Trusted_Connection=yes;','SELECT top 10 * FROM pcm.stats.visits') AS a

I get the below error:

"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication"

I understand from the error that the domain and mode of authentication is different.

I use windows auth and we are given sql auth on the remote server which is on different domain.

I was suggested to use 'sp_addlinkserver' to link the remote server and query the data.

I am just curious to know if we can succeed through link server, is there any script to use sql authentication of remote server in my procedure and pull the data.

View 9 Replies View Related

Migrating From Sql2000 MSDE Database To Sql2005 Express - Attach Database Errors

Apr 23, 2006

I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.

Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:


Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.


Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them.  But I should still be able to switch over to sql 2005?!?!?!?


Or... is there a way to attach the databases to SQLExpress manually?

Help pls?

View 1 Replies View Related

Transferring Data From MSDE Database To SQL 2000 Database

Jul 23, 2005

Hi all,Here is my situation.I have an application that uses SQL 2000. The client has a programthat uses MSDE. The client MUST have the MSDE version of the Database.What I have done is to create a SQL 2000 Database that is exactly likethe MSDE version. What I wish to do, is at regularly scheduledintervals, update the SQL 2000 Data with the newest MSDE Data.On my clients server, they have both MSDE and SQL 2000 installedthe msde has a user name and password to access it, whereas the SQL2000 uses authenticated mode to access it.What I'm trying to do is to write a bunch of SQL Queries, that I canrun that will copy over the new Data, but I'm having problems accessingthe msde database in query analyzer from the SQL DatabaseCan anyone give me hints on the best way to try thisThanksScott

View 1 Replies View Related

Right Code Statements Of SqlConnection &&amp; ConnectionString For Connecting A Database In Database Explorer Of VB 2005 Express?

Feb 14, 2008

Hi all,

In the VB 2005 Express, I can get the SqlConnection and ConnectionString of a Database "shcDB" in the Object Explorer of SQL Server Management Studio Express (SSMSE) by the following set of code:
///--CallshcSpAdoNetVB2005.vb--////

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Public Class Form1

Public Sub InsertNewFriend()

Dim connectionString As String = "Data Source=.SQLEXPRESS;Initial Catalog=shcDB;Integrated Security=SSPI;"

Dim connection As SqlConnection = New SqlConnection(connectionString)

Try

connection.Open()

Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)

command.CommandType = CommandType.StoredProcedure
.......................................
etc.
///////////////////////////////////////////////////////
If the Database "shcDB" and the Stored Procedure "sp_inertNewRecord" are in the Database Explorer of VB 2005 Express, I plan to use "Data Source=local" in the following code statements to get the SqlConnection and ConnectionString:
.........................
........................

Dim connectionString As String = "Data Source=local;Initial Catalog=shcDB;Integrated Security=SSPI;"

Dim connection As SqlConnection = New SqlConnection(connectionString)

Try

connection.Open()

Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)

command.CommandType = CommandType.StoredProcedure
........................
etc.

Is the "Data Source=local" statement right for this case? If not, what is the right code statement for my case?

Please help and advise.

Thanks,
Scott Chang

View 6 Replies View Related

Need To Establish A Remote Connection To An Sql Database On A Local Server (same Domain)

Feb 16, 2007

Hi, I have been creating a web store, which we will be hosting on our Windows Server 2003 system.  I am also writing a windows application that will be running on our client systems on the same network/domain.  I have no need to allow internet access to the database, just within our domain.  Pretty much the windows application will be running and whenever a customer places an order, the program will automatically pop-up the needed information for our credit card processing, and shipping department.  So far I have been able to establish a connection to our server by creating a data connection under the server explorer.  However, it does not list any databases whatsoever, the web site has been published using Visual Studio 2005 Professional on the server, and is in 100% working order.  I have searched and haven't found anything concrete on this, i'm sure its just something simple that im missing.  It appears that the server is definetely connected to the database (since the website is fully functional), but it is not listing the information for other systems to access it.  If anyone has any ideas, please let me know.  Thank you

View 8 Replies View Related

How To Capture The System Errors As Well As Database(s),Domain Erros Like Even Viewer

Nov 19, 2007



Hi

Is it possible to capture the errors which raising in System,Databases,networking using SQLServer UDB(assume DBA Database).
or
Is it possible to store all Errors(system,Databases,networking...Services failure...)in SQL Server UDB.

View 1 Replies View Related







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