Weird Issue On Client Laptop
Jul 20, 2005
A user is having issues with replication. The message states it can't
find a database. This database is on the distributor. When I go to
Enterprise manager and add that server with a valid logon (I even
tried logging on as sa), and I look at the databases. They are NOT
the databases that exist on that server. They are the databases that
are on the client (laptop)'s SQL Server. I've reinstalled sp3 (SQL
2000), and rebooted. Went to SQL Query Analyzer and connected to that
server, and still could not see the databases that exist on that
server (still showing the local sql server's databases).
I can connect to the publisher, and other servers that are running sql
server, and they show the correct databases. No one else is having
this problem.
Has anyone out there ever seen this before? (I couldn't find a virus
on the laptop either).
Thanks,
Amy M
View 3 Replies
ADVERTISEMENT
Mar 27, 2007
What'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?
View 5 Replies
View Related
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
May 14, 2004
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 Related
Jun 29, 2001
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 Replies
View Related
Oct 26, 2000
i 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
View 2 Replies
View Related
Jan 26, 2007
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.
View 11 Replies
View Related
May 30, 2008
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 Related
Jul 31, 2006
I 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
View 1 Replies
View Related
Mar 6, 2008
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 .?
View 1 Replies
View Related
Jan 14, 2004
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
View 1 Replies
View Related
Jun 27, 2001
I 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 Related
Feb 23, 2005
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
View 2 Replies
View Related
Jan 3, 2008
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?
View 9 Replies
View Related
Apr 28, 2008
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.
View 2 Replies
View Related
Aug 13, 2007
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
View 15 Replies
View Related
Feb 21, 2008
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
View 5 Replies
View Related
Jul 20, 2005
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 Related
Mar 9, 2006
If 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
View 7 Replies
View Related
Jan 31, 2007
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
View 20 Replies
View Related
Oct 10, 2006
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
View 10 Replies
View Related
Jul 23, 2005
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 Related
Mar 27, 2008
When 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
View 2 Replies
View Related
Jun 29, 2015
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
May 12, 2008
Hello all!
I want to get into consulting (perhaps a little at first and more once I can support myself on it solely). I am about to start the purchase of a laptop soon, and I want to know which components I should focus on the most. I also want to know which version of SQL Server I should purchase.
From my studies and what I have learned (about to take the test to get my sql server 2005 certificate) I am going to assume that I want to get SQL Server 2005 developer software. However, the part that is not touched on very often, is if I am working with a client that has say, SQL Server 2005 enterprise, x64 exition, and I have developer IA64 edition, would I be able to connect and work on their server?
As far as the hardware is concerned, I am thinking I want a laptop with a large enough screen (I currently get a discount through hp where I currently work and am looking at the models that have a 17 inch screen) so I don't go blind trying to work . I am also thinking I don't need an extremely powerful processor, but I am not sure between athlon and pentium on which I Should choose since I do not have much experience in this area with sql server. I know I want at least 2GB of memory for the simple fact that sql server isnt the only thing I will be doing on the laptop and want some headroom. I also want a large enough hard drive to hold everything, but I definitely want to see if I can get a 7200rpm drive vs a 5400rpm for the simple fact that I have noticed a significant difference in read and write speeds between the 2 drives. I am not too fussed over the video card, as I am not into graphics design or high-end video games (I think world of warcraft is the most intense I have bought in years). I am also thinking that because I wont need to have a very powerful video card, that a mega powerful battery is not super important.
These so far are my thoughts. Please let me know your opinions on what I should focus on/get
View 3 Replies
View Related
May 28, 2001
We have 15 clients running our applicaton
14 of then conected to SQL server using TCP/IP and it runs fine
1 of 15 when connected using TCP/IP produce "..Time out error "
but runs fine when swiched from TCP/IP to Named pipes
1.What area should we look to correct problem with Time out using TCP/IP ?
2. Where to get information about using TCP/IP via Named pipes ?
View 1 Replies
View Related
May 10, 2006
Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
View 78 Replies
View Related
May 2, 2006
On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?
View 2 Replies
View Related
Nov 1, 2006
Hi,
I have SQL2000 installed as the default instance, and now I'm trying to install SQL 2005 standard edition as a named instance.
I receive this error :
SQL Server could not connect to database service for server configuration.. [SQL Native client] Encryption not supported on the client. However I'm able to install client tools
The setup works fine on other box with the same config : SQL 2000/Windows XP, is there any work around for this issue ?
In my SQL 2000 client network utilty "Force proctocol encryption " is desabled and did not find the setting for SQL 2005 !
Thank you
View 1 Replies
View Related
Mar 17, 2008
Hi Guys!
I want to buy a laptop, so that I can install and play with the trial SS 2005 Enterprise Edition and hopefully get familiar with SSIS. At work I have only used SS 2000. I want a laptop which will run this with a reasonable speed, but don't want to pay for more juice than is actually required. Does anyone have any advice on what kind of spec would be good enough for SS 2005 Enterprise? If I go for the basics suggested by the system requirements, will it run like a tortoise?
Thanks!!
Clare
View 3 Replies
View Related
Jun 17, 2015
I 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]....
View 7 Replies
View Related
Jan 3, 2007
I tried to set up mirroring on my laptop.
I have got two instances of SQL Server 2005 SP2 on my laptop (the first one is the default instance).
Checked configuration running the following scripts
SELECT type_desc, port FROM sys.tcp_endpoints;
GO
SELECT state_desc FROM sys.database_mirroring_endpoints
go
SELECT role FROM sys.database_mirroring_endpoints;
GO
SELECT 'Metadata Check';
SELECT EP.name, SP.STATE,
CONVERT(nvarchar(38), suser_name(SP.grantor_principal_id))
AS GRANTOR,
SP.TYPE AS PERMISSION,
CONVERT(nvarchar(46),suser_name(SP.grantee_principal_id))
AS GRANTEE
FROM sys.server_permissions SP , sys.endpoints EP
WHERE SP.major_id = EP.endpoint_id
ORDER BY Permission,grantor, grantee;
GO
Everything is OK on both instances. Tried to start mirroring and I have got this error message:
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'Northwind'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The server network address "TCP://kookaburra.sydney.ssw.com.au:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
I could connect to both instances:
C:Documents and SettingsSergeiTchernykh.SSW2000>sqlcmd -U sa -P <password> -S k
ookaburra,5022
1> exit
C:Documents and SettingsSergeiTchernykh.SSW2000>sqlcmd -U sa -P <password> -S k
ookaburrasydney2005,5023
1> exit
I could ping my laptop
C:Documents and SettingsSergeiTchernykh.SSW2000>ping -a kookaburra
Pinging kookaburra.sydney.ssw.com.au [10.0.0.1] with 32 bytes of data:
Reply from 10.0.0.1: bytes=32 time<1ms TTL=128
Reply from 10.0.0.1: bytes=32 time<1ms TTL=128
Reply from 10.0.0.1: bytes=32 time<1ms TTL=128
Reply from 10.0.0.1: bytes=32 time<1ms TTL=128
Ping statistics for 10.0.0.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
Thank you.
View 4 Replies
View Related
Jul 23, 2005
Hello,Is it necessary to upgrade the Client Connectivity Tools on all clientmachines after the SQL Server database server is upgraded from Version7.0 to 2000?Thank you in advance!Eddy
View 1 Replies
View Related
