Newbie - New Install Client Config Problem
Feb 13, 2000
Hi,
I've just set up a new installation of SQL 7 in a WinNT4/sp5 machine so I can learn more about this stuff and I'm trying to configure a Win98 client. From the Win98 client all looks well on the surface. Interestingly when I click on the server from within the Win98 MMC/Enterprise Manager it attempts to establish a dial-up connection to my ISP. The only network protocol I have running is TCP/IP.
Also, I can do what ever I want from within Enterprise Manager and SQL Analyzer but if I attempt to execute a script using the OSQL utility at a dos prompt as follows
osql /Usa /P /i "c:sqlimplexercisech02myscript2.sql"
I get the following error
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect()).
Any clues as to what I need to do to straighten this out? I have a DSN for the server which tests successfully using TCP/IP on the default port 1433.
View 2 Replies
ADVERTISEMENT
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
Jun 22, 1998
I would like to be able to change the configuration of a remote machine`s SQL client config.
Can anyone provide me with the registry location of where it stores the protocol and libraries?
Can`t always depend on having someone at remote to run the SQL client app.
TIA Sam Janney
View 1 Replies
View Related
Jul 20, 2005
Anyone support a config where you have an unix/linux (AIX here) ODBCclient connection to SQL Server database? I am looking for a simple,supportable configuration that does not require me to learn perl orinstal a bunch of crap gnu shareware on enterprise class machines.Please help!
View 3 Replies
View Related
Feb 5, 2008
We are trying to deploy reporting services with SQL 2K5 SP2. In our DEV environment, all services are running on a single box. Obviously we don't want the IIS piece running on top of PRD SQL server, and want to deploy the IIS piece on our PRD web boxes, but hit our PRD SQL cluster for the data (and report srvcs databases).
Does anyone know of a whitepaper or tech doc that will describe in step by step detail how to deploy Rpt Srvcs in this way? We don't have any core competency with report services, so we're not sure how to proceed in our TST environment which must mimic our anticipate PRD deployment.
Thanks!
View 1 Replies
View Related
Jan 22, 2008
Hi:
Glad to find this forum.
I have a MS Access application, just moved the database table from .mdb to sql2005.
I notice in my office pc, from "ODBC Data Source Administrator" ->tab: "Drivers", only have one item listed which is: "SQL Native Client", file name is: SQLNCLI.DLL.
Is that .dll includs most of the drivers which needs to link to MSSql from MS Access?
From my home pc, under the "Drivers" Tab, not only has "SQL Native Client", but also has: SQL Server, file name is: SQLSRV32.DLL.
Do I need include both of them, if that is true, I need to install SQLSRV32.DLL in my office pc.
Any suggestion will be really appreicated!
Thank you very much.
jt
View 3 Replies
View Related
Nov 1, 2007
Hello,My goal is to setup and configure the "Community MySQL server" onmy "Vista" laptop. I want to run the server and clients on the same"machine" using the "loopback" IP addr (127.0.0.1) to talk betweenMySQL clients and the MySQL server.1) When I run the Config Wizard, I get the following message:"The security settings could not be applied. Error number 2003.Can't connect to the MySQL server". I checked via the Vista TaskManager and there was a MySQL server instance running. I am probablymore of a POSIX API programmer .. in any case I remember that onWindows 2000 that there was some kind of "system log" .. can't find iton Vista(through the Control Panel) to get a better error message. Cansomebody point to the "system log" or help me with the error message?2) I finally tried to run the "mysql_install_db" script to"instantiate" a MySQL database instance. I ran this script from a"http://www.cygwin.com" shell because the script is a Unix script. Igot the error: "FATAL ERROR: Could not find SQL file '/mysql_system_tables.sql' in @pkgdatadir@ or inside C:/Program."Suggestions please.Kind regards, Vasya
View 1 Replies
View Related
Dec 19, 1998
I have installed SQL6.5 on my NT4.0 server.
I go into the enterprise manager. There are currently no registered servers. I try to add a server under the SQL 6.5 group and get the following message:
"Unable to connect to Server(reason [SQL Server Login failed]. Register Anyway?"
The service is running. I can login through the command prompt, but when I type select @@servername it comes back as NULL.
I have tried both my NT SA account as well as the SQLExecutiveCmdExec account. TIA - pwb
View 1 Replies
View Related
Feb 28, 2006
I want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best.
While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.
I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.
Thanks for your help.
Steve
View 1 Replies
View Related
Aug 16, 2006
Hello,
I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated!
View 9 Replies
View Related
Feb 7, 2008
For MS Press Book, ADO.NET 2.0 Step by Step, 2005 Edition by Rebecco Riordan, installing the code samples created a ConfigDB.exe file
under SampleDBs folder. Running this exe file created a AdoStepByStep into the Database
folder in SQL Server 2005 Express.
However, for ASP.NET 2.0 Step by Step, 2005 Edition, by George Shepherd, there is no Config.exe to install the ASPNETDB SQL Server
2005 Express database. I right clicked the Database folder to 'Attach' the database. But,
the database just showed a 'c: ASPNETDB.MDF filfe path as a name. Further, running
the aspx files in Chapters 7 and 12 showed a 'Timeout Expired' error msg, indicating
something wrong with accessing the SQL Server database.
How can I run the aspx files in Chapters 7 and 12? How can I install the ASPNETDB?
TIA,
Jeffrey
View 4 Replies
View Related
May 25, 2001
Hello,
I am upgrading existing databases through the wizard from 6.5 to 7.0. If I leave the databases in 6.5 mode do I need to install the SQL 7.0 client?
Thanks,
Darrin Carter
View 1 Replies
View Related
Oct 26, 2000
I am trying to install the SQL Server 6.5 client utilities and constantly get the infamous
"setup.exe has caused an invalid page fault in kernel32.dll" message.
I have scoured the web and found many suggestions for resolving this issue but nothing helps.
Has anyone suffered this same fate? Any ideas on how to resolve it?
View 3 Replies
View Related
Oct 16, 2006
Here's what I'm going for:
I have an 05 VB.NET windows application that will be used as a smart client for our folks in the field. The windows application includes 05 SQL Server Express. I have included in the Data Sources of my project and attached file going through the wizard Microsoft SQL Server Database File (SqlClient) ='s (myfile.mdf) and then selected all tables, views, stored procedures, and functions... the corresponding myfileDataSet.xsd with the myfile.mdf are now located in the root of the project. I now recompile the project without error and go to the properties section Publish tab... select the Application Files button and myfile.mdf Publish Status is set to Include and the Download Group set to Requried. With this in place I right click on the myfile.mdf from the Soultion Explorer and under the properties section have set the build action to compile and use the copy always setting for the Copy to Output Directory.
My app.config looks like this:
<configSections>
<sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
<section name="myfile.My.MySettings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
</sectionGroup>
</configSections>
<connectionStrings>
<add name="myfile.My.MySettings.ffgscrmConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|myfile.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
After the publish is completed on the client machine... install for WIndows Installer 3.1, SQL Server Express, and the Windows Application contains no data but everything else works fine.
My problem is that I need to attach the myfile.mdf to the new SQL Server Express instance on the client machine during the installation process so that when the application fires it will be pointed to the above location on the client.
Anyone have any ideas... scripts... includes for an ApplicationEvents.vb, source code on how to do this correctly?
Kind regards,
BillB
View 6 Replies
View Related
Dec 8, 1998
Can we install SQL client on another domain to access the SQL server on another domain? If can, Pls say how to?
View 2 Replies
View Related
Sep 15, 2006
I note that I can install SSIS on a client box not just a server. What is the advantage (expect maybe if the client is a portable computer) to installing SSIS on a client box? I would normally expect to find it running on the server side of the house.
TIA,
Barkingdog
View 1 Replies
View Related
Nov 1, 2007
Hi all,
Im currently using SQL server 2005 Management Studio. I need to export files from SQL database to Access database.
But I dun think SISS is installed. Can anyone advise where to look for the file to install? Thks in advance.
Wee
View 5 Replies
View Related
May 31, 2004
In Server Explorer of VS .NET 2003, I tried to generate SQL script of the dbo.Portal (ibs)
but got
"To use this feature, you must install the client tols for SQL Server"
When I searched for Help, I've got
"1.Insert the MS SQL Server 2000 compact disc in your CD-ROM drive"
I installed and use MSDE and cannot recall the use of any CD for installation.
1)
Does it mean that I cannot install client tools from MSDE installation?
If not...
2)
I have installation of MS SQL Server200 Enterprise that cannot be installed on Windows Xp Professional that I use. Can I still install "client tools" from Enterprise Ed. for MSDE
View 2 Replies
View Related
Dec 15, 2005
I'm running XP w/ SP2 and I tried to install just the client tools (management solution) from a SQL 05 Standard Edition. Don't have any kind of SQL sever or client tools installed (like older version or express). The install goes really quickly and installs successfully. When I try to go to Start - All Programs - SQL Server nothing shows up? It seems that nothing was installed. What am I doing wrong. Any ideas? All I'm trying to do is to connect to a SQL2005 server from a workstation with the new Management tool (the new version of Enterprise Manager). Thanks!
View 3 Replies
View Related
Jan 4, 2001
We are running SQL Server 7.0 on an NT Server in an NT environment. We have Service Pack 2 installed on the server hosting the database. Do we need the service pack installed on the client machines? Even if they only need client connectivity? Also does anyone know what fixes sp3 is supposed to fix? We are running our production environment without any known problems using sp2 and really dont want to disrupt it with sp3 if its not needed. Thanks in advance.
View 4 Replies
View Related
Aug 9, 2007
Hi
I am developing a Report Project ,that contains some reports
using VS.Net ,My task is to install these reports on client Machine.
Is there any option to add a "Set Up Project" to the Report Project solution, so that client may run this setup project(.exe) to install the reports in his server.
My Main requirement is , client can install these reports into his machine by executing a set up file.
Is this possible?, Please suggest me a good solution
View 1 Replies
View Related
Nov 14, 2006
I have SQL Server 2000 client installed in my machine and I need to call stored procedures thru sqlcmd utility. When I tried using this utility, I got an error message from command prompt sqlcmd command does not exist.
I have osql utility in my client version, but i need to have sqlcmd utility.
Please advice how do I install sqlcmd.exe in my SQL Server client?
View 1 Replies
View Related
Jun 20, 2006
I'm trying to do an unattended install of the client components for SLQ2005. I have read the document on doing a install from the command prompt but when I use the "ADDLOCAL" switches I get some components that I don't require. For example, I am using the following command to run the setup - "start /wait <path>setup.exe ADDLOCAL=Client_Components,SQL_Tools90,Connectivity". When I look at the Add/Remove Programs list I can see that it has installed "MSXML 6.0 Parser", "SQL 2005 Backward Compatibilty" and "Office 2003 Web Components". The only components I require are the "SQL Support Files", "SQL Server Native Client" and " CLient Tools". If I run "start /wait <path>setup.exe REMOVE=SQLXML,TOOLS_BC_DEP" it will remove "Office 2003 Web Components" and "SQL 2005 Backward Compatibilty" but not the "MSXML 6.0 Parser". How can I get rid of this?
Thanks for any help.
View 1 Replies
View Related
Oct 13, 2006
Hi,
We just moved from SQL 2000 to SQL 2005 Ent. To use SSIS service, I need install this package on client side. But when I install the 2005 on my PC(Win XP Prof), I did not find any place I can include it. Anyone has similar experience or know how to do it?
Thanks in advance,
Jie
View 9 Replies
View Related
Jan 8, 2008
I'm building a new server and am having a problem witht he SQL install. It's a Dell 2905 running Windows 2003 SP1 x64 and SQL 2005 x64. I'm able to install everything except for the Client Components, and even upgrade to SQL SP2.
I keep getting the following error:
"There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information"
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643
------------------------------
BUTTONS:
OK
------------------------------
The problem is that I can't find any solutions to this so far. Anyone recognize or have any insight into this?
View 4 Replies
View Related
Sep 21, 2006
One user has an HP x64 Athalon box and IS installed Windows XP, 32 bit edition, on it. Today I installed the sql 2005 x86 client on this box, but the install came back saying that the "minimum hardware requirments" were not met. I need to know exactly what has not been met. Where can I look?
TIA,
Barkingdog
P.S. When I tried to install the sql 2005 x64 clinet on the same box the OS replied "not a valid 32 bit app". Well, duh!
View 2 Replies
View Related
Feb 23, 2007
Hello,
I am kind of new with .Net development and really new with using SqlExpress. Here is my question, I hope it is easy:
I have a shareware program that I have been selling since 2000 and it was written in VB6 using a third party database program. What I would like to do is rewrite this application using C# and SqlServer Express. The program as it stands right now is about 5mb to download and install.
My concerns:
1) How do I embed and quietly install sqlserver express to the end user's computer without them having any intervention?
2) By using sqlserver express as my database how much extra overhead is going to be included in the install package? I want to keep the install package as small as possible and the user experience of installing the program as painless as possible.
Thanks in advance,
View 8 Replies
View Related
May 13, 1999
I can't get the OLAP Manager to install on my client PC running Windows95. It does install on the server running NT4.0.
I want to remotely administer the OLAP, just like I do with the Enterprise Manager on the client. Anyone have any suggestions?
Do you have to have NT on the client?
View 1 Replies
View Related
Dec 19, 2001
Is there a way to extract (and copy to a network drive) the necessary files from the SQL Server 2000 CD for the purpose of a creating a client install directory? I would like to invoke the Setup from the network. I do not want to place the whole CD on the network. I do not necessarily want to have to re-key the serial number (product key) every time a client install takes place.
View 1 Replies
View Related
Dec 27, 2007
I'm trying to remember how to install the SQL 2000 client tools onto a SQL 2005 server. There are a couple of bizarre steps that will allow this to happen, but I can't for the life of me remember what comes after the unicycle down the stairs with the umbrella stand of machetes.
Can anybody remember the magic, or do I resort to using VPC to kludge the install until I can find my clay tablets again?
-PatP
View 5 Replies
View Related
Feb 11, 2008
I am new to SQL Server 2005.
Windows 2003 Server SP 2
SQL Server 2005
Unable to locate client connectivity software ntwdblib.dll Check with your miscrosoft SQL Server database administrator to install the appropriate client software.
Where will find Client software and how do we install that.
Please advice. Thanks.
View 5 Replies
View Related
Feb 2, 2007
Hi all... assisting with mass deployment of SQL 2005 Client Tools.
Multiple users are able to pass the System Configuration Check, and click Next. It is on the next screen they see the following:
Microsoft SQL Server 2005 Setup [_][X]
-------------------------------------------------------------------
Microsoft SQL Server Installation
Setup is preparing to continue with the installation.
-------------------------------------------------------------------
Please wait while setup prepares to continue with the installation.
Status: Extracting custom action file from stream
________________________________________________
[________________________________________________]
[Help] [< Back] [Next >] [Cancel]
After eight minutes, the install bombs, and sends an error report to Microsoft.
I saw a similar post here, but these are XP machines and Administrators appear to have the proper permissions. I also do not get the error message "Error writing to file".
Here is a section of the _WI log file generated by the install..
MSI (c) (48:A4) [09:20:49:208]: PROPERTY CHANGE: Adding ENABLERANU property. Its value is '1'.
Action ended 9:20:49: SetEnableRanuUI. Return value 1.
MSI (c) (48:A4) [09:20:49:208]: Skipping action: UnsetEnableRanuUI (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Skipping action: SetSharedVolumePath (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Skipping action: UnsetINSTALLSQLDATADIR (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Extracting custom action file from stream
Action start 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (48:44) [09:20:49:223]: Invoking remote custom action. DLL: C:DOCUME~1axn4835aLOCALS~1TempMSI117.tmp, Entrypoint: StreamSupportFiles
MSI (c) (48:70) [09:20:49:223]: Cloaking enabled.
MSI (c) (48:70) [09:20:49:223]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (48:70) [09:20:49:223]: Connected to service for CA interface.
Action ended 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
MSI (c) (48:A4) [09:20:49:301]: Skipping action: FatalError (condition is false)
Action ended 9:20:49: INSTALL. Return value 3.
MSI (c) (48:44) [09:28:50:859]: Destroying RemoteAPI object.
MSI (c) (48:70) [09:28:50:859]: Custom Action Manager thread ending.
And here is a section of the _Core(Local).log
Running: ReportChainingResults at: 2007/0/29 9:28:57
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 2992
A section of _Core.log:
Running: LaunchLocalBootstrapAction at: 2007/0/29 9:19:37
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1603
Aborting queue processing as nested installer has completed
When the install fails, this is the event signature:
EventType: sql90setup
P1: unknown
P2: 0x643
P3: unknown
P4: 0x643
P5: unknown
P6: unknown
P7: sqlrun.msi@9.00.1399.06
View 5 Replies
View Related
Aug 27, 2007
I'm working on a C# 2008 project, when i add a CE Database to it, then publish the app, the installer wants to download and install the entire SQL Server Express product on the client machines. My understanding is that I should be able to embed this database right into the app, but it defeats the purpose to have the installer download and install the entire express product (the actual project is 1 meg).
Is this expected behavior? or am I doing something wrong?
View 3 Replies
View Related
