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

Best Way To Download DBs To Laptop

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

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

I Have Transferred To A Server From Laptop

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

Create A Copy Of A SQL Db On A Laptop

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

Installing SQL Server 7.0 And 6.5 On A Laptop

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

Cant Install Sql Serverr On My Laptop

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

Creating A Database On A Laptop

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

Installing SQL Express In Laptop

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

Querry About Drivers For My Laptop.

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

How To Connect To A Local Sql Server On Your Laptop?

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

How To Copy A Database From A Server To A Laptop

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

Problem Installing MS-SQLSERVER On Laptop

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

Connect To Sql Server 2005 From My Laptop

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

Windows Authentication From Non-domain Laptop

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

Can I Use Sql Server 2005 On My Standalone Laptop

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

Can I Have SQL Server 2005 And 2000 On My Laptop?

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

Sony Laptop With AMD Processor - Cannot Install SQL

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

After Laptop Goes Into Standby, SQLEXPRESS Won't Start

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

SQL Server 2005 Studio Crashing Laptop (BSD)

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

Print Model Number And Price For All PC's And Laptop's Made By IBM (was Help)

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

How To Recover SQL Database From A Removed Laptop Hard Drive?

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

Connection Problem Using Work Laptop When On Home Network

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

Possible To Restore DB Files On Local Laptop To Review Code

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

Want To Start Consulting In Future, Need Help With Laptop And Sql Server Version

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

Client With Tcp/ip Produce "time Out Error" While Same Client While Switced To Named Pipes

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

Install SQL Server2005 Error:[Native Client]Encryption Not Supported On The Client

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

Client Unable To Establish Connection Encryption Not Supported On SQL Server. (Microsoft SQL Native Client)

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

Setup Error : [SQL Native Client] Encryption Not Supported On The Client

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

Suitable Laptop Spec For Running SQL Server Enterprise Edition

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

SQL Tools :: Copy Database Wizard Fails On New Windows 8 Laptop?

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

Could Not Start Mirroring On A Single Laptop With Two Instances Of SQL Server 2005

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

Upgrade Client Connectiviity Tools On Client Machines

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







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