Rookie Needs Help With What To Do After Installation.
Sep 9, 2006Any guidance to get me off the ground would really help
ADVERTISEMENT
PLEASE Help A Rookie
Jan 26, 1999Hello,
I would like to create a SQL Server DB on my win95 machine...I have VB Studio 97 Enterprise Edition loaded on my machine.
When I go to Interdev and try to create a Project (via New DB wizard) the first question is "What Server do you want to create your DB on?"
I haven't found ANY documentation that details how to set up the Client and the Server on the SAME machine.
1) Can you set up SQL Server in a way that the same machine is the Client and the Server?
2) Do I need anymore software than VB Studio 97 Enterprise Edition? (To setup a SQL Server DB on my machine)
I basically need guidance on how to create a DB on my local machine, so I can reference it in my ASP application.
I appreciate your help, RB
Rookie Question
Mar 21, 2006Hi,
I'm trying to read the most recent entries in a table of data.
Its fairly straightforward because there is a timestamp saved when I write into the table.
For a table with the following columns
Username, description, location, timestamp, result1, result2
I can select the max timestamp for a username and it will return the most recent date/time that an entry was written to the table for that particular user. No problems with that.
However, what I really want is to select the most recent timestamp for each location for each username; I also need the result1 and result2 fields returned.
Thus for the following table:
user description location timestamp result1 result2
Jo Red Hall 01/01/06 Yes Yes
Jo Blue Hall 01/02/06 Yes No
Jo Blue Deck 01/04/06 No No
I would like a query to return:
Jo Blue Hall 01/02/06 Yes No
Jo Blue Deck 01/04/06 No No
The problem is if I do
Select max(timestamp) as Tmstp, description, user, location, result1, result2 from tblSomeTble
I will get
Jo Red Hall 01/01/06 Yes Yes
Jo Blue Hall 01/02/06 Yes No
Jo Blue Deck 01/04/06 No No
because some of the results are different and thus the SQL will return the most recent entry for each unique combination of user, location, result1 and result2.
I've solved the problem by doing two separate database reads; the first does a simple
Select max(timestampdescription) as Tmstp, user, location
then I use VB.net to fill a dataset and read these values from the dataset and plug them into a second SQL for a second database read like:
Select max(timestamp) as Tmstp, description, user, location, result1, result2 from tblSomeTble where timestamp = [timestamp from first sqlread] and user = [user] and location = [location from first sqlread]
it all works fine, but I'm aware its messy and probably not very scaleable to have multiple database reads that are unnecessary. It must be a commonly encountered problem though? How do other people handle this? is there a common solution people use?
thanks
Rookie Question
Jun 13, 2006I have a database on my development machine and its working fine. And I want to duplicate the database schema on the production server. What is the easiest way to do this?James
View 1 Replies View RelatedRookie Sql Question
Oct 10, 2006SQL, It's up and running, 2000.
Looking in enterprise manager at the server, Green right handed arrow(running) with a red squiggly line?
What is that? (mean)?
Thanks
Backuping Up Database --- ROOKIE ---HELP !!
Nov 9, 2000I am getting an error backing up databases on a remote SQL Server. I have tried using two options:
1. All tasks, Backup Database... (Enterprise Manager)
2. Database Maintenance Plan Wizard
In both cases, I get the following error:
2000-11-09 18:21:34.93 kernel BackupDiskFile::CreateMedia:
Backup device 'FMSSQLBACKUPwOLTP_db_200011091821.BAK' failed to create.
Operating system error = 5(Access is denied.).
What are the exact NT and SQL Server permissions needed to perform backups.
Also, I am able to write manually to the backup directory not through the SQL Server application.
NOTE: ALTHOUGH I WAS ABLE TO REGISTER THE REMOTE SERVER USING USER sa,
I CANNOT STOP OR START ANY OF THE SERVICES (SQL SERVER AGENT...)
OR CONFIGURE THEIR STARTUP ACCOUNTS (GREYED OUT)!!
PLEASE HELP
THANKS
SHELLY
SSIS Rookie Question
Apr 10, 2008Hi everyone,
I'm new to SSIS. I need to Extract, transform and load data from one SQL table to another. I want to do something like "select count(a) from table 1 where ...."
I have define the following Data flow items on the package designer, I believe that OLE DB source & OLE DB Destination, are correctly configured, however i don't see how can i transform data on the "OLE DB COMMAND" item....should i use "data conversion" instead ?
ps: is there any site where i can find examples of data transformations ?
Rookie Question About Query/View
Jul 23, 2005I have much MSACCESS expeience and am new to SQL so here goes...I am trying to create calculated fields in a view, but can't seem tomore complex calculations to work.I can create a new field which does simple arithmetic on two otherfields and rename it so it becomes part of the new view to be queriedby other views, but when I use more complicated constructs I can'tseem to get them to work.For starters:How do you create a new field that has a number based on an IFconstruct based on another field.Example:field1 has state abbrevs and field 2 should have a "1" if field1="NY".In access I do field2:IIF(field1="NY",1,0),How do I accomplish this in MS SQL.Can it be done in the view?Thanks,Brad
View 7 Replies View RelatedIncrementing Number In A Column -- Rookie Sql User
Jul 23, 2005Sorry to bother you guys with what I though would be an easy task. Ihave a table in my database were I would like one of the rows toincrement a number for each row. I want the first row to start at 1000and keep on incrementing by 1 'till the end of the rows (about 2.7million rows). I though this would be a piece of cake, but I just can'tseem to find anything like it on the internet...weird.Anyways, I'm just a rookie in sql, any help would be appreciatedThanksJMT
View 6 Replies View RelatedRookie Question? Peer-to-Peer Replication Not Detecting Conflict
Mar 8, 2007Hi
Sorry for asking what may be a rookie question... We have configured transactional peer-to-peer replication in a testing environment with two servers, each publishing and subscribing to each other. If we write a piece of code that updates the same row on both servers with different values, we are not seeing data conflict issues. The data updated on server 1 propagates to server 2, but at the same time data updated on server 2 is updated on server 1. This leaves the records on each server out of data.
I expected my test case to produce errors, but instead I got inconsistent data. How do you turn on data consistency checking?
Thanks in advance
SQL Tools :: SSDT For VS2012 Installation Fails With (Same Architecture Installation) Error
Mar 9, 2013The 6:th of march Sql server data tools for Visual Studio 2012 was released.
[URL]
I seem to be unable to install this using the link provided on the blog page. I'm getting a "Same architecture installation" error. Running on the machine is Visual Studio 2012 Premium & Sql Server 2012 (64bit).
why I'm getting this installation error.
Error Installing SQL Server2000: A Previous Program Installation Created Pending File Operations On The Installation Machine
Oct 2, 2005I am trying to install SQL Server 2000 on a Win2K OS machine but Iget this error message:"A previous program installation created pending file operations onthe installation machine. You must restart the computer before runningsetup."I see others have had this problem but have fixed it using the solutionin:http://support.microsoft.com/defaul...kb;en-us;312995I have tried the solution but to no avail. The registry key:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetContro lSessionManagerPendingFileRenameOperations keeps reappearing as soon as Iclose RegEdit.Any ideas?Thanks,lq
View 3 Replies View RelatedMSDE Installation Fails Due To Detection Of Previous Installation
Jul 23, 2005Please help,I am trying to install MSDE 2000 so that Backup exec will run on thisserver. I have gotten so far as to find an entry in my SQLSTP.TXT filethat says that c:mssql7 was detected so the install fails.Now, to start with there is no directory called C:mssql7 on thisserver. I have gone through all MS articles on manual removal of SQLserver and instances. I have searched the registry for mssql7 andremoved any keys that matched, as per MS article I have searched onSQLBOOT.dll and it is not present anywhere on my system and I still getthe same results.2:07:44 Begin Action: Detection12:07:44 SQL Server version already installed: 7.00.62312:07:44 Previous Install SQL Path: C:MSSQL712:07:44 Previous Install SQL Data Path: C:MSSQL712:07:44 End Action Detection12:07:44 Begin Action: ODBCLocked12:07:44 End Action ODBCLocked12:07:44 GetDefinition returned: 112:07:44 Previous SQL Server ProductType: MSDE [0x4]12:07:44 This combination of Package and Operating System allows a fullproduct install.can anyone think of anything here..what else could be causing the server to think there is a previousversion of SQL 7 on this box!!!?
View 1 Replies View RelatedExpress Installation Fails With Invalid Installation Package
May 3, 2006I get an error when trying to install the SQL Native Client. It
says it cannot find the installation package and to use a valid copy of
'sqlncli.msi'. I've downloaded the Express setup twice and get
the same error from both of them.
I'm attempting this in a VMWare session setup for Windows 2K, Advanced
Server. I am trying to test my installation and setup
procedures. This is not a production setup, just install testing
and documentation. I have allocated only 272MB to the VMWare
session, which is why the system doesn't meet the recommended settings.
Any help would be greatly appreciated.
Below is the Summary.txt output file.
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Wed May 03 09:54:23 2006
CPCWIN2KVM1 : The current system does not meet recommended hardware
requirements for this SQL Server release. For detailed hardware
requirements, see the readme file or SQL Server Books Online.
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : SQL Native Client
Error : An
installation package for the product Microsoft SQL Server Native Client
cannot be found. Try the installation again using a valid copy of the
installation package 'sqlncli.msi'.
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Failed
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SQLNCLI_1.log
Last Action : InstallFinalize
Error String : An installation package for the
product Microsoft SQL Server Native Client cannot be found. Try the
installation again using a valid copy of the installation package
'sqlncli.msi'.
Error Number : 1706
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_MSXML6_1.log
--------------------------------------------------------------------------------
SQl Server 2005 Installation Is Depend On Installation Of Visual Studio 2005?
Oct 2, 2006Hi every one,
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
Installation Seems To Be OK But ...
Feb 28, 2004Hello,
Yesterday, to start SQLServer, I have used the DOS Command
setup SAPWD=xxx from C:sql2ksp3MSDE.
I think tne mix mode of authentification is correct.
But when I want to connect to the database by SQLEntMan, it doesn't work ...
How can I connect to SQLServer ?
Server adress = name of the computer
Username = ?
Password = password of windows ? password of of SAPWD ?
Thank you any help
Ben
Installation
Jun 2, 2005Hi, I ama trying to install SQL Server Express 2005, when the setup.exe does an anlysis of the machine configuration it tellme that out of 10 checks one has failed, and that the machine needs tobe rebooted in order to fulfill a requirment from a previous installation, I did this and went to start the installation process again only ot be told that this check failure still exists, unfortunately I cannot progress, has anybody experienced this, I am using Windows XP Hone, with ASP.NET 2.0 installed and Web Dev Express 2005 Beta 2Looking forward to hearing fom you
View 3 Replies View RelatedSQL 7 INSTALLATION ON WIN`98
Aug 17, 1998I am trying the SQL 7 STANDARD installation on WIN`98. However, it creates the directory structure on the hard-disk alonwith files but on connecting to server it comes out with a VC++ assertion failed message.
The TCP/IP sockets are being used and the TCP/IP port (local ping) is working fine. Windows 98 was installed again and there are no prequisites for SQL 7 on 98 but the problem persists !
Anyone who has installed it on WIN`98 ?
TIA
Raghu
SQL 7.0 Installation W98
Apr 22, 1999I have problems after installation in W98 of the Desktop.
In Enterprise Manager when I try to connect to the server gives the following error:
Assertion failed!
program c:windowsmmc.exe
file: ../src/sqlsspi.c
line: 119
Expression: Count
after I click on RETRY and gives the error:
a connection could not be establish to TEST05 - [SQL-DMO]code execution exception:
EXCEPTION_BREAKPOINT.
Please verify SQL SERVER is running and check your SQL Server registration properties and try again.
I check, and in Service Manager is TEST05 - MSSQLServer - running.
Also in Query Analyzer gives an error:
Assertion failed!
program c:mssql7innisqlw.exe
file: ../src/sqlsspi.c
line: 119
Expression: Count
after I click on RETRY and gives the error:
This program (ISQLW) has performed an ilegal operation and will be shutdown
ISQLW caused an exception 03H in module MSVCRT.dll at 0177:7800...
Where is the problem? From wrong installation or W98?
The installation CD was camming in the book :
"Special Edition" - Using SQL SERVER 7.0 from Stephen Wynkoop.
Please reply,
Tanks.
Installation Of SQL 7.0
Nov 13, 2001Hi:
We ran SQL Replication in Production SQL 7.0 with SP1. We encountered some problems. We ran the same tests in QA which used SQL 7.0 with SP1. The problems were gone.
Both Production and QA used SQL 7.0 with SP1 but they came from different resource CDs. Production one was installed from Microsoft Select CD in 1998. I did not recall the CD which was used for QA.
It indicated those two SQL 7.0 functioned differently and Production on had a bug in it. Can somebody to share with me a detecting tool and a criteria to find out where is wrong in the Production SQL 7.0?
Thank you.
Joan
Installation
Mar 6, 2001Hi,
I am having pentium 3 with windows 98 I had Sql Server 7 installed But due to some problem i uninstalled it.
I am having difficulty in reinstalling the same i uninstalled completely and even removed entries in registry and tried to install But i am getting the same error always.
1)Acmsetup failed
2)setup failed to configure the server Refer to the server error logs and cnfgsvr,out for more information
There is nothing in server error logs
cnfgsvr.out file looks like this
Starting Service ...
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
What is ACMSETUP what it does how i can prevent its failure is the failure of ACMSETUP a reason for sqlserver set up failure
I appreciate ur replies
Sql Installation On Xp
Oct 7, 2002I have installed sqlserver 2000 (desktop edition) on my pc at home. I am running windows xp home edition. what i am finding is i am not able to log in to either Enterprise Manager or Query Analyzer. I have tried using different accounts during installation.
The service has started and the server seems to be running, but I cannot make a connection.
any suggestions,
thanks,
jim
SQL Installation
Jul 30, 2001We have installed SQL Server 6.5 in an NT system. We are able to start and stop the server from a client enterprise manager, but unable to connect to the databases there(ie., we are able to right-click on the server and start and stop the server but unable to right-click and connect to the server). Can anyone help us out with this?
View 1 Replies View RelatedInstallation
May 28, 2008Hey guys, I'm new to this and had some general questions. I'm currently running windows xp pro with sql server 2005 tools installed. However I cannot deploy any of the reports due to not having IIS installed. I've now installed IIS however, do I need to completely uninstall SQL Server 2005 tools and is there a particular order to uninstall it in order to get everything to work?
As you can see I'm totally lost/new to this.
Installation - Pls Help
May 30, 2008I tried to install sql server 2005 professional Edition in my machine.While doing the step by step installation, it was not showing the " Instance name " and " server accounts" ( i.e whether it is built-in system account or domain user account) slides and so finally i am not able to complete the installation. Kindly help me to rectify this. Thanks in advance.
View 1 Replies View RelatedSQL Installation
Jun 6, 2008Hey Guys,Im going to install the SQL Server 2005,can any one tell me what are the things do i need to know before the installation.Its 64 bit and clustered.Active/passive
View 2 Replies View RelatedInstallation
Oct 27, 2005I am new with SQL and have a question regarding SQL Connections. I have 2 Win2003 Servers(tom and Jerry) setup with Microsoft Cluster installed in Active-->Active Mode. Also, on both of these servers, I have SQL 2000 installed in Active-->Active mode as well. So I installed SQL2000 on Tom first and gave the SQL server name of Dog1 which has and IP assigned to it, at the same time I gave an instance name of D1. So now my SQL on Tom server reads Dog1D1. I did another installation on Tom and gave it Dog2D2. Than I went and installed SQL again on Jerry, this time and gave name of CatC3, and CatC4.
Now in my DNS, I have Dog1, Dog2, Cat3, Cat4 defined with an IP I assigned.
Problem I am running into is I cannot connect my application or make and ODBC connection to Dog1D1, Dog2D2, Cat3C3 or Cat4C4. I am getting Server not found message.
Can anyone help me and tell me where I am going wrong, as I need to get this app up ASAP.
Thanks,
Jay
Installation
Nov 3, 2005Hi guys,
i am new to the forum. i got sql server 2000 and i wanted to install it on my home pc. i am able to do that.
But when i create a database out of it and then take it out of the SQl folder and put it in some other folder in my C: drive and then if i try to link it to my program it gives me a error stating that it is not accessible.
MY QUESTION : Am i doing something wrong ?
Do i have to set some properties on the database i
create?if yes how to do it?
Plz reply
Thanks
Installation
Sep 24, 2007Hi,
SQL Server 2005 has been installed on windows server 2003 machine by the support team.
Microsoft SQL Server Management Studio9.00.3042.00
Now this machine has been passed on to me to create databases, tables, etc...
On this server, I open the management studio and I get the connect to server windows.
What should the entries in the connect to server window be for me to get to the next stage where I can start building databases.
At present, I tried local or localhost and windows/sql authentication.
Still can not get to the management studio window.
Any thoughts please?
Thanks
After Installation
Nov 12, 2007Hi experts,
I have installed SQL server 2005 Standard edition and SP2 in production box, after completion of installation the perticual production server is not connecting, but every other servers are getting connect through that instance, and one more main issue is i could not able to see this instance in SERVICES.MSC, I was wondered, how come it is not showing!!!!!!!!!!!!!!!!
-Thanks N Regards,
Kanthi.
Installation Help
Dec 4, 2007hi
i m trying installing sqlserver 2000 in my PC(WIN XP). all the process are happening properly.. but while starting SQL and Configuring the database the setup exists and throws the message to check sqlstp.log.
when checked, i got this error.... please help
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=RAVIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=RAVIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=RAVIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
thanks in advance
regards
Ravin
Db Installation
Jul 23, 2005HiWe have the following setupW2k server with IIS 5.0Asus P4P800E Deluxe MoboP4 2,8 Mhz - 1 Gb Ram3 sata harddisks1 hd = 2 partitionsc: boot/systemf: backup2 hd's in a raid 1 (mirror) Promise controllere: webrootWhere would be the best partition to install a MS SQL2000 databas?It's possible to install a 4th ide harddiskKitty
View 3 Replies View RelatedSQL CE 3.5 Installation
Oct 8, 2007
Hi,
I had SQL Mobile installed on my XP PC. As I wanted to use INSERT IDENTITY, I uninstalled SQL Mobile from my Pc. Now I see two problems:
1. Even after uninstalling SQL Mobile and rebooting my PC, I still see SQL Mobile option when I start SQL Server Mgmt Studio. Any reason why?
2. I then installed SQL CE desktop runtime (nearly 1.8 MB) and rebooted my Pc. Now when I go to Query Analyzer, I still cannot use IDENTITY Insert.
3. There seems to be two versions of CE download: one for desktop and one for mobile. Can anyone let me know which one I should download for desktop? And for deployment on device which version I need to download?
Regards,
vj