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
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.
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.
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!
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.
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.
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
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
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.
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!
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?
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?
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.
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?
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.
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.
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
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!
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.
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
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?
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?
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?
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?
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!
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.
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?
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.
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?
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.
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:
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?