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


ADVERTISEMENT

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

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

Error Installing SQL Server 2005 (32Bit) On A Laptop With Windows 2003 Standard Edition

Dec 3, 2007

I am attempting to install SQL Server 2005 on a Laptop with Windows 2003 Standard Edition.

The installation fails and the File Summary.txt has the following entries:


Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Time : Fri Nov 30 09:36:53 2007

Machine : SAPDEMO
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.

Time : Fri Nov 30 09:38:41 2007

List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SCC.log


The Log File, SQLSetup0004_<hostname>_Core.log, has the following entries:

Microsoft SQL Server 2005 Setup beginning at Mon Dec 03 08:54:09 2007
Process ID : 2980
C:SAP_CDCD2x86EnterpriseEditionServerssetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/11/3 8:54:9
Complete: LoadResourcesAction at: 2007/11/3 8:54:9, returned true
Running: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9
Loaded DLL:C:SAP_CDCD2x86EnterpriseEditionServersxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9, returned true
Running: ValidateWinNTAction at: 2007/11/3 8:54:9
Complete: ValidateWinNTAction at: 2007/11/3 8:54:9, returned true
Running: ValidateMinOSAction at: 2007/11/3 8:54:9
Complete: ValidateMinOSAction at: 2007/11/3 8:54:9, returned true
Running: PerformSCCAction at: 2007/11/3 8:54:9
Complete: PerformSCCAction at: 2007/11/3 8:54:9, returned true
Running: ActivateLoggingAction at: 2007/11/3 8:54:9
Complete: ActivateLoggingAction at: 2007/11/3 8:54:9, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2980" returned false.
Running: PerformSCCAction2 at: 2007/11/3 8:54:9
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042
Complete: PerformSCCAction2 at: 2007/11/3 8:54:9, returned true
Running: PerformDotNetCheck at: 2007/11/3 8:54:9
Complete: PerformDotNetCheck at: 2007/11/3 8:54:9, returned true
Running: ComponentUpdateAction at: 2007/11/3 8:54:9
Complete: ComponentUpdateAction at: 2007/11/3 8:55:6, returned true
Running: DetectLocalBootstrapAction at: 2007/11/3 8:55:6
Complete: DetectLocalBootstrapAction at: 2007/11/3 8:55:6, returned true
Running: LaunchLocalBootstrapAction at: 2007/11/3 8:55:6
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1605
Aborting queue processing as nested installer has completed
Message pump returning: 1605

Regards

View 1 Replies View Related

Issues In Installing Sqlserver 7.0 SP1

Sep 28, 1999

HI, I am having difficulties in installing sp1 for sql server 7.0. Does anyone have similar issues. Any one can enligth me with his/her experience. thanks for your help

Ali

View 2 Replies View Related

INstalling SP4 For MS SQLServer 2000

Jul 23, 2005

I'm updating my local database installation using my netowrk login asthe id under which SQLServer is being update (Administrator on theoperating system and SA role on the database server itself).Has anyone encountered any problems and what is the work-around?

View 1 Replies View Related

Installing SQLServer In A Raw Volume

Jan 29, 2007

Hi All
I would like to know whether SQLServer can be installed in a raw volume or not..... Is there best practice guide for this. .
Regards,
Vijay

View 2 Replies View Related

Installing SQLSERVER Express

May 25, 2007

After installing Visual Studio 2005 everything has installed fine EXCEPT SQLSERVER 2005. I remember having had the same problem some moths ago, but can't remember now how to fix it. I deinstalled VS2005 and installed back again, but the result was the same. SQLSERVER failed to install



thanks

View 4 Replies View Related

Problem After Installing Sqlserver 6.5 Sp5a

Dec 16, 1999

we have a client that just upgraded to sp5a and are encountering problems...one stored procedure seems to routinely become corrupted, and does not complete correctly. however, it does not error out, and the only way to tell that it did not complete successfully it to query the data.

the only solution that i have found to this problem is to recreate the procedure. i have tried using sp_recompile to force a recompile at next runtime, and the problem still occurs. i have tried recreating the calling procedure, and recreating procedures it calls, but neither fix the problem.
after recreating the procedure, it continues to run fine for anywhere from 1 hour to 8 hours, and then starts to fail again.

microsoft so far has not been able to give us help in diagnosing this, and i am coming up with nothing in my own investigations.

has anyone seen a problem like this in sp5a?

also, it is occurring on 5 similar dbs that are on the same server...

thanks
carl

View 2 Replies View Related

Installing SQLServer 2000 Service Packs On Clustered Server

Aug 30, 2005

Hi,I am planning to install sql server 2000 sp4 on my clustered serverrunning in active/passive mode.I plan to stop all sql services using cluster administrator, installthe service pack from the primary node and then reboot all nodes.Are there any missing steps that need to be done or problems thatanyone has come across?ThankLyn

View 3 Replies View Related

Problems Installing SQLServer 2000 Developer Edition On Windows XP Pro

Jul 20, 2005

Hello!When trying to install SqlServer 2000 Developer (as Administrator) on myWindows XP Professional I get the following message at the point wherethe system asks Local Account or Domain account:The logon account cannot be validated for the SQL server service. Verifythat the user name and password entered are correct. The logon attemptfailed.Anyone an idea what goes wrong here?Thanks for your info.Daniel*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

Account Permission For Installing/running Sqlserver And Service That Accesses It

Nov 15, 2007

Hello,

I am totally confused by what account I should be running my sql server database and my business layer service as.

I take it that when installing sqlserver and my service that I should be logged in as administrator.

Should I be using "Local Service", "Local System" or "Network Service" to run these processes as?

Summary of my business layer service
* Clients connect to this service on a tcp/ip port
* It accesses the file system
* it connects to the database

Thanks,
JP

View 4 Replies View Related

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

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

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

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

Weird Issue On Client Laptop

Jul 20, 2005

A 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 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







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