We have a laptop that has SQL 7 installed on it, and we would like to copy an existing database to the laptop. The laptop does not have any connectivity to our network. I did backup the database on the network, and place the backup copy on a CD. I then was hoping that I could create a new DB on the laptop and restore the copy from the CD. But, I have not been able to figure this out. Can anyone help?
View 4 RepliesI need to copy a database from our SQL server box to a laptop. What is the best way to accomplish this?
View 4 Replies View RelatedI have a new Windows 8.1 64-bit machine onto which I have installed everything that I had on my previous Windows 7 machine. Occasionally I like to use the Copy Database Wizard in SQL 2012 to create a copy of a database on my stand-alone laptop before I begin a new stage of development on it. However, I have failed to run it successfully on my new Windows 8 laptop, despite everything apart from the operating system being identical to my Windows 7 machine, on which I never encountered a problem.
do not suggest using backup instead of the Copy Database Wizard, as if something has worked for me perfectly for 15 years I would like to know why it does not work now. The error message that I receive is shown at the end of this message.
The log-on accounts for SQL Server Agent and SQL Server Integration Services 11.0 are NT ServiceSQLSERVERAGENT and NT ServiceMsDtsServer110 respectively, as they were on my Windows 7 machine. All services are running. Why I receive the error stating, "Arithmetic operation resulted in an overflow" for every database that I have tried to copy, including a new database with no tables that I created to see if I still received this error. As I said, the problem relates to trying to copy databases onto the same machine on which the original database exists.
Event Name: OnError
Message: Failed to connect to server XXXXXXX.
StackTrace:Â Â Â at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
  at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp)
InnerException-->Arithmetic operation resulted in an overflow.
[code]....
Hello,
We are building a smart client that ships with it an offline db - Sql Express.
I wanted to check if there is a preferred/recommended approach to deploy the database ? I'm essentially asking between
1. Copying a database file and
2. Creating the database file by connecting to Master and issueing create database etc and then running the scripts as we need it.
Any help will be great,
Thanks,
Avinash
PS: The app is a multi user app and may be used by multiple windows users on the same machine. So we currently use the Auto Attach feature in the connection string with database files in the Special Application/User Data folder. So we isolate files b/w users.
Hi
I have a table with a user column and other columns. User column id the primary key.
I want to create a copy of the record where the user="user1" and insert that copy in the same table in a new created record. But I want the new record to have a value of "user2" in the user column instead of "user1" since it's a primary key
Thanks.
Hi,
I have a database on the server which is in production and I would like to create another copy and use it for testing purpose. so the application can point to the test database for testing purpose.
What is the best way to do? I guess I have to name the test one with different name right?
can I do it without detach the production one? or just copy the database - tables structures from the currnet one?
Thanks!
I have a table I'd like to copy so I can edit it and play around withthe data. How do I create copy of a table in SQl Server?Thanks,Bill
View 5 Replies View RelatedHi,
How do I create a copy of an existing database using vb.net? I have not been able to find solutions to the problem using vb.net. Can someone please help me. Thanks
Thanks
I want to create an exact copy of a system running SQL 2000.
I want to copy MDF and LDF, but I cannot bring server down cause it works 24x7. What can I do?
All,
I am trying to create a copy of an existing database and place on a different sql server for testing purposes. Currently my method of doing this is to create a backup, then restore a database on my new sql server. But here is the problem I am running into. When I look in Enterprise manager I can see all of the stored procedures and tables and data just fine, which is how I would like it. But, when I open up Query Analyzer I am not able to run any queries because it says "invalid object name" error. I know that the object name is correct. I think that I am having a conflict between the users which were carried over from the source backup file and the users that are on my 2 new sql server. If anyone could help, I would really appreciate it. I am stuck at this point. I am guessing it is probably something simple I am just unaware that I need to do.
Thanks,
LinsLo
I have a database that I have been creating and testing. I have added some junk data and some data into lookup tables. Is there a way to create a clean copy of the db and keep the lookup table data? Also will I be able to create the db under a new name?
View 1 Replies View RelatedWhat's a good way to download five SQL Server 2005 databases from production to my laptop for development work with Visual Studio?
Our application code is under source control, but to have a current development environment I must keep downloading these databases. Four databases are small, but one will need to be trimmed to about 10% of actual size to fit on my laptop's hard drive.
Looking at options in the Management Studio by right-clicking on each database, I see options to export the data, create a backup. Or, am I making this too hard and the easiest way would be to download some backups of the database created by the maintenance plan and use those to restore them on my laptop?
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.
I have transferred my program to a 2000 server and while programming it was automatically using the local ASPNET login and when transferring it to the server it says that it is having problems logging into the sql server using an anonymous login. How do i change the program so that it can use the sa login or some other assigned login?
View 5 Replies View Relatedi have a toshiba Satellite Pro 4300 laptop (15 GB and 64mb Ram and NT Server 4.0 service pack 6)...in other words enough space to install the two..
i installed SQL Server 7.0 (server)..it runs fine..but after this, when i install 6.5 on it, it goes thru the installation process and comes back with an error message saying 'access denied'...i have logged in as administrator so access rights should not be a problem...the CD is fine because i have done the same process on a desktop without errors...if someone can throw some light on this problem, it will be highly appreciated
thanks in advance,
resh
i unistalled sql server and try to install it but its giving an error.
anyone knowhow to fix it?
i restarted the laptop already too'
also im able to install analysis services.
I am trying to learn SQL and in order to do so i need to have a test database to test and practice my queries, unfortunately i dont have a server to hold a database on so im trying to create a new database on my laptop. I have the SQL statements that will create and populate a table, but everytime i try to create a new database i appempt to connect to localhost?? and try to create a database, but it says i dont have permission or the object doesnt exist...im confused. any help will be greatly appriciated.
View 10 Replies View RelatedI am trying to install MS SQL Express Advanced in my Laptop to be used in conjunction with ColdFusion programming environment. Abs newbe with MSSQL.
It looks like the Management Studio Express has not been installed. I have tried to install the 64bits stand alone from msdn.microsoft. but my processor does not support it.
Please please advise.
ThankYou very much
ContiW
i lost my laptop driver's cd,right now i am using windows XP professional.and laptop is of compaq v3000.
so from where i get my laptops driver,can you help me out .?
i have problems connecting to the local server on my laptop. i ahve used the following code but it gives me an error saying login flaied for user "sa" or "sekhar".
i tried using the username and password i use to log onto my computer. but it doesnt work.
can anyone tell me how to do it?
the code is typed is
connection = new sqlconnection("server=localhost;uid=sekhar;pwd=sekhar;database=chandu")
........................
......................................
...............................
connection.open()..................i have all the next statements correct.
my username is sekhar and the password is sekhar too but it gives me an error.
somebody help me
Thank you
sekhar
Hello Friends at dBForum !!
:confused: I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration:
Pentium III
Brand :Toshiba
Speed: 500 Mhz
RAM : 192 MB
Hard Disk :6 GB
Space Available:4 GB
O.S.:Windows 98
The computer works pretty good and run different applications. I was trying to install MS-SQLSERVER 2000 and I checked out the software and hardware requierements for that and everything seems to be fine. The reason that I need it its because of my trips, and its incredible I have a desktop computer with almost the same configuration and runs pretty good.
When you have a problem installing SQL-SERVER 2000 you have a file called cnfgsvr with all the explanation. I got this at hand so you can see better the problem:
Iniciando servicio ...
Conectando con el servidor ...
driver={sql server};server=3110CT;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]No existe el servidor SQL Server o se ha denegado el acceso al mismo.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
driver={sql server};server=3110CT;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]No existe el servidor SQL Server o se ha denegado el acceso al mismo.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
driver={sql server};server=.;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]No existe el servidor SQL Server o se ha denegado el acceso al mismo.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).
Error de configuración del servidor SQL Server.
This is what I got after the installation fails: Here is the log sequence, and I got this from a file called sqlstp2000:
14:37:28 CoreCOM
14:37:28 CoreCOMRes1033
14:37:28 CoreCOMResIntl
14:37:28 CoreTool
14:37:28 CoreToolRes1033
14:37:28 CoreToolResOther
14:37:28 DBLibCli
14:37:28 SFExt
14:37:28 SFExtActiveX
14:37:28 SFExtActiveXRes1033
14:37:28 SFExtActiveXResIntl
14:37:28 SFExtRes1033
14:37:28 SFExtResIntl
14:37:28 Trace
14:37:28 TraceRes1033
14:37:28 TraceResOther
14:37:28 MiscCore
14:37:28 MC
14:37:28 MCMC1033
14:37:28 MCMCIntl
14:37:28 MCHelp
14:37:28 SQLMgr
14:37:28 SQLMgrRes1033
14:37:28 SQLMgrResIntl
14:37:28 SvrTool
14:37:28 SvrToolRes1033
14:37:28 SvrToolResIntl
14:37:28 DTSUI
14:37:28 DTSUIRes1033
14:37:28 DTSUIResIntl
14:37:28 MSOlap
14:37:28 MSOlapRes1033
14:37:28 MSOlapResIntl
14:37:28 ATL
14:37:28 ATLwinnt
14:37:28 ATLwin9x
14:37:28 MFC42U
14:37:28 VC
14:37:28 VB
14:37:28 SQLAdHlp
14:37:28 SQLAdHlpRes1033
14:37:28 SQLAdHlpResOther
14:37:28 {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:37:28 End Action LogSelectedComponents
14:37:28 Begin Action InstallPkgs:
14:37:28 Begin Action: Locked Connectivity Files Check
14:37:29 ConnectivityLocked returned: 0
14:37:29 The operation completed successfully.
14:37:29 End Action: Locked Connectivity Files Check
14:37:29 El programa de instalación está instalando Microsoft Data Access Components (MDAC)...
14:37:29 E:X86Othersqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
14:38:10 ExitCode: 0
14:38:10 El programa de instalación está instalando Microsoft Management Console (MMC) ...
14:38:10 E:X86Otherinstmmc.exe /Q
14:38:36 Process Exit Code: (0)
14:38:36 Se está instalando el Coordinador de transacciones distribuidas de Microsoft (MSDTC)...
14:38:36 E:X86Otherdtcsetup.exe /q:a /r:n
14:38:53 Process Exit Code: (0)
14:38:53 /Q:A /T:C:WINDOWSTEMPixp001.tmp
14:38:53 El programa de instalación está instalando la Ayuda HTML...
14:38:55 HTML Help installer exit code: 0
14:39:18 End Action InstallPkgs
14:39:18 Begin Action MoveFileData:
14:39:18 Enabled SELFREGISTERBATCH
14:39:18 Enabled CORECOMPONENTHANDLING
14:42:27 ComponentMoveData exit code: -117
14:42:27 ComponentMoveData: -117
14:42:51 No se puede leer el archivo especificado. Puede ser a causa de una conexión de red de bajo rendimiento. Corrija el problema y reinicie el programa de instalación. ( This message says that the computer can not read the specified file or its a problem related to a network connection of low performance. According to the message here shown, I have to fix the problem and reinstall. ) I did it, even I deleted the entries related to this on the windows registry and after restarting the problem stills...
Archivo: E:X86SETUP....Install
eplmerg.sql
14:42:51 Begin Action: MoveFileDataSpecial
14:42:52 End Action: MoveFileDataSpecial
14:42:52 Action CleanUpInstall:
14:42:52 StatsGenerate returned: 2
14:42:52 StatsGenerate (0x0,0x1,0xf0000,0x0,1034,303,0x0,0x1,0,0,0
14:42:52 StatsGenerate -1,Alessandro)
14:42:52 Installation Failed.
On the other hand, I tried to install MS-SQLSERVER 7.0 ( you know if I can get do it with MS-SQLSERVER 2000 ) and this is what I got :
2005-02-17 13:08:26.77 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows 4.10 (Build 2222: A )
2005-02-17 13:08:26.84 kernel Copyright 1987-1998 Microsoft Corporation.
2005-02-17 13:08:26.84 kernel Reservados todos los derechos.
2005-02-17 13:08:26.84 kernel Registrando los mensajes de SQL Server en el archivo 'C:MSSQL7logERRORLOG'.
2005-02-17 13:08:27.00 kernel initconfig: número de conexiones de usuario limitado a 32767.
2005-02-17 13:08:27.01 kernel SQL Server se iniciará con clase de prioridad 'normal'( se detectó 1 CPU).
2005-02-17 13:08:27.21 kernel User Mode Scheduler configured for thread processing
2005-02-17 13:08:28.61 server Directory Size: 8087
2005-02-17 13:08:28.68 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2005-02-17 13:08:28.74 spid1 failed to get sqlservr image range
2005-02-17 13:08:28.78 spid1 Advertencia ******************
2005-02-17 13:08:28.79 spid1 SQL Server iniciado en modo de usuario único. Se permiten las actualizaciones en los catálogos del sistema.
2005-02-17 13:08:28.79 spid1 Advertencia ******************
2005-02-17 13:08:28.79 spid1 Recovering only master database
2005-02-17 13:08:28.85 spid1 Iniciando la base de datos 'master'.
2005-02-17 13:08:28.85 spid1 Opening file C:MSSQL7datamaster.mdf.
2005-02-17 13:08:28.97 spid1 Opening file C:MSSQL7datamastlog.ldf.
2005-02-17 13:08:29.06 spid1 Cargando el método de intercalación Unicode de SQL Server.
2005-02-17 13:08:29.16 spid1 Cargando el orden y conjunto de caracteres no Unicode de SQL Server.
2005-02-17 13:08:29.41 spid1 4 transacciones confirmadas en la base de datos 'master' (1).
2005-02-17 13:08:29.41 spid1 0 transacciones deshechas en la base de datos 'master' (1).
2005-02-17 13:08:29.65 spid1 El servidor no tiene nombre.
2005-02-17 13:08:29.65 kernel Se utiliza 'SQLEVN70.DLL' versión '7.00.623'.
2005-02-17 13:08:29.72 kernel Se utiliza 'OPENDS60.DLL' versión '7.00.00.0623'.
2005-02-17 13:08:29.83 ods Utilizando 'SSMSSH70.DLL' versión '7.0.623' para escuchar en ''.
2005-02-17 13:08:29.89 ods Utilizando 'SSMSSO70.DLL' versión '7.0.623' para escuchar en '1433'.
2005-02-17 13:08:30.09 ods Utilizando 'SSMSRP70.DLL' versión '7.0.623' para escuchar en '3110CT'.
2005-02-17 13:08:31.11 spid1 El método de intercalación Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'English' (Id. = 1033).
2005-02-17 13:08:31.11 spid1 estilo de comparación = 196609.
2005-02-17 13:08:31.11 spid1 El orden no Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'nocase_iso' (Id. = 52).
2005-02-17 13:08:31.11 spid1 El juego de caracteres no Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'iso_1' (Id. = 1).
2005-02-17 13:08:31.19 kernel Warning: override, autoexec procedures skipped.
2005-02-17 13:10:23.67 kernel SQL Server terminará debido a una petición de 'detención' del Administrador de control de servicios.
Accordiing to the message shown in the bottom line, we may see its like the installation were stopped because of a request of the Control Service Manager. I never stop the installation or something like that but I dont have a clue why or where is the problem here.
My desktop computer is standalone and works without problems. Of course I read that if you have PWS ( Personal Web Server ) running you may need to stop that first, and then proceed. I did it and it never worked.
If you have any suggestion about it, this would be greatly appreciated.
Thank you so much,
Cordially,
Alessandro Barbieri - Peru
all,
I have the standard edition of SQL Server 2005 installed on a WIN XP Pro machine. I setup file and print sharing with my laptop. What do I need to be able to connect to SQL Server on my WIN XP Pro machine from my laptop. I hope to do most of my developing on my laptop. Do I need the developers edition of SQL server 2005 installed on my laptop?
We have a SQL 2005 box that requires windows authentication but I have to connect a laptop that is not part of the domain. Is there any way to do this? Per company policy, the SQL server cannot be changed to use SQL Auth AND Windows Auth. Also per policy, the user's laptop cannot be joined to the domain since it's not a company laptop.
I've tried using the following command:
net use \SQLServerNameipc$ /user:DomainNameDomainAccount Password
and then using enterprise manager to register the sql server but it still says that the computer is not trusted.
Is there something else to this that I am missing or is this just not possible?
Thanks in advance for the help.
Can someone please tell me if i can use SQL Server 2005 on my standalone laptop, and how do i connect, i dont know how to set up the password so i can connect
Many thanks Rob
Im trying to install SQL Server 2000 and 2005 on my XP SP2 laptop. If I can do so, which versions(i.e. standard, express, desktop, etc) are compatible ?
Thank you
I have above server and I cannot install MS.SQL server on it.I have WIN-xp professional.I tried sql 2000 personal version as well as sql 2000 professional version,it says "cannot install on this operating system "I would appreciate if someone please help me.Thanks.
View 2 Replies View RelatedA user is having issues with replication. The message states it can'tfind a database. This database is on the distributor. When I go toEnterprise manager and add that server with a valid logon (I eventried logging on as sa), and I look at the databases. They are NOTthe databases that exist on that server. They are the databases thatare on the client (laptop)'s SQL Server. I've reinstalled sp3 (SQL2000), and rebooted. Went to SQL Query Analyzer and connected to thatserver, and still could not see the databases that exist on thatserver (still showing the local sql server's databases).I can connect to the publisher, and other servers that are running sqlserver, and they show the correct databases. No one else is havingthis problem.Has anyone out there ever seen this before? (I couldn't find a viruson the laptop either).Thanks,Amy M
View 3 Replies View RelatedIf my laptop goes into standby with the MSSQL$SQLEXPRESS service running, the service will not start again. I get the following error messages in my log:
2006-03-06 20:49:08.45 Server This instance of SQL Server last reported using a process ID of 1764 at 3/6/2006 1:48:21 PM (local) 3/6/2006 9:48:21 PM (UTC). This is an informational message only; no user action is required.
2006-03-06 20:49:08.45 Server Error: 17053, Severity: 16, State: 1.
2006-03-06 20:49:08.45 Server UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
2006-03-06 20:49:08.45 Server Registry startup parameters:
2006-03-06 20:49:08.45 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-03-06 20:49:08.45 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-03-06 20:49:08.45 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-03-06 20:49:08.56 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-03-06 20:49:08.56 Server Detected 1 CPUs. This is an informational message; no user action is required.
2006-03-06 20:49:09.32 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-03-06 20:49:09.35 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-03-06 20:49:09.35 spid5s Starting up database 'master'.
2006-03-06 20:49:09.68 spid5s SQL Trace ID 1 was started by login "sa".
2006-03-06 20:49:09.76 spid5s Starting up database 'mssqlsystemresource'.
2006-03-06 20:49:10.03 spid5s Failed to check for new installation or a renamed server at startup. The logic for this check has failed unexpectedly. Run setup again, or fix the problematic registry key.
2006-03-06 20:49:10.03 Server Error: 17182, Severity: 16, State: 1.
2006-03-06 20:49:10.03 Server TDSSNIClient initialization failed with error 0x5, status code 0x90.
2006-03-06 20:49:10.03 Server Error: 17182, Severity: 16, State: 1.
2006-03-06 20:49:10.03 Server TDSSNIClient initialization failed with error 0x5, status code 0x1.
2006-03-06 20:49:10.03 Server Error: 17826, Severity: 18, State: 3.
2006-03-06 20:49:10.03 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2006-03-06 20:49:10.03 Server Error: 17120, Severity: 16, State: 1.
2006-03-06 20:49:10.03 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
Uninstalling, reinstalling and restoring the databases fixes the problem. Also, is there anyway to gracefully shut down the service on standby? Any help would be greatly appreciated.
Thanks,
David
I just recently replaced my old HP laptop with a Sony VAIO. I installed all of my development software on it, including SQL Server 2005 and the studio. At some point when I am using the studio on this new laptop, if I try to resize any of the columns to better fit the data, it crashes my laptop. I get the infamous Blue Screen of Death.
The laptop is a Sony Vaio BX670P and it has Win XP SP2 with all of the latest and greatest updates loaded on it.
The BSD blames a driver for causing the crash and points out "win32k.exe" specifically. This has never happened to me before.
Does anyone know why this might be happening?
- - - -
- Will -
- - - -
http://www.strohlsitedesign.com
pls help
you have these relations
Product(model, Maker, type)
pc(model, speed, price)
laptop(model, price)
pc-model and laptop-model is refering product-model
1. how do i write a code to print model number and price for all PC's and Laptop's made by IBM?
2.Print the Maker who has the most number of products?
thanks
kusal
Dear group:I have removed my hard drive from my laptop (which is now toast) andhave managed to recover nearly all the data from it by installing thedrive into my desktop. I was hoping to reboot the dektop to see if Icould load the operating system on the laptop's hard drive so I coulddo a manual backup of the SQL database on it. This does not work.Does anyone know of a way to recover my SQL database and all its tablesgiven the circumstances above?TIAISZ
View 5 Replies View RelatedWhen using my Work laptop while at home, how can I log into an SQLServer Express 2005 database on a home server, using Windows Authentication, without having to VPN in and log onto the network at Work? If I VPN into work then I can connect to my home db just fine.
I have a laptop which I carry from work to home each day. I'm a Domain Admin at work so my network login name is DOMAINjoe. At home I have 5 PCs in a home network, WorkGroup is WORKGROUP. When I carry my laptop home I log in exactly as I do at work. All is fine. File sharing, printer sharing, & internet all work between my 5 PCs.
I installed SQLServer Express 2005 on a home PC I use as a server (Vista Business edition). Home server's name is STAR. I developed a database called AddressBk on my laptop (Visual Studio 2008) using my laptop's local copy of SQLServerExpress. App works fine. I copied the Db files onto my home server STAR. My user name on STAR is Joe2, so while logged onto Star as Joe2 I used Star's SQLServer Management Studio Express to connect the AddressBk db to Star's copy of SQLServer Express. All is fine.
Now if I use my LapTop on my home network and try to connect to AddressBk on STAR I get a connection error. I get the error whether connecting using SQLServer Management Studio Express or using Visual Studio 2008. The SQLServer Management Studio Express connection screen shows I'm connecting using Windows Authentication and my User Name is DOMAINjoe. I presume this is the problem as I can not add a user on Star with a Domain Name. Other PCs on my home network can connect to AddressBk db on Star without a problem. If my labtop VPNs into work then I can connect just fine.
Here is the connection string my App uses.
Data Source=STARSQLEXPRESS;Initial Catalog=AddressBk;Integrated Security=True;connection timeout=60
How can I connect to my db without having to VPN into work?
Thanks for any help.
Joe A
I have an automation project to review the software. The software is using MSVS2012 and uses DBs from MSSQL2012. Is it possible to restore the DB files on my local laptop to review the code completed thus far? If so what other software would I need besides MSQLserver 2012 on my local laptop.  I'm able to use MSSQL server 2012 on my local laptop, but the DBs are on servers.Â
View 4 Replies View Related