There are two instances: SQL2005 and SQL2005Express on two different units. While there is Visual Studio 2005 Team Edition also installed on the units have not attempted these component installs through either yet. Have spent the better part of two days, following all the directions having searched help locally, online, technet,and applied their advice respectively. While I've taken out the old instances, downloaded updated ones in both my SQL Server instances they do not show as installed under Programs->SQL Server (whichever instance)->Tutorials ...However they do show installed in Control Panel and they can be found via Explorer (AdWorks DBCI+AdWorks BICI and Express instance on the other unit. Have also download SP2 and installed it, but this has proved of no help. @ My wits' end, any help will be appreciated.
Where can I find some documentation about the ExternalActivator sample available on gotdotnet.com? I'm looking for a tutorial how the sample can be set up and used...
Thanks
Klaus Aschenbrenner www.csharp.at http://www.sqljunkies.com/weblog/klaus.aschenbrenner
to download AdventureWorksDB.msi. Once I save that to my local machine I run the install and it completes with no errors. Unfortunately, I can't see any of the data in SQL Server Management Studio Express. I'm new to SQL Server Express so maybe its me, but I get the feeling that it was never added to the database. I'm still looking for SQLServerExpressSamplesOverview.htm to see if I am missing a step but I can't find it anywhere.
The install seems to have extracted database files but if I need to run some scripts by hand to create the database I don't know which order to run them in.
I have installed MS SQL Server 2014. When I try to attach the pubs database that I downloaded, I'm getting an error saying that its non-release version (539) is not supported by this version of SQL Server.
My question is: Is there a way that I can either get an updated version of the database from Microsoft, or update the one I have?
I have installed SQL Express 2005 together with VS 2005. After a while I found out that the sample databases (Northwind and Pubs) were missing, so I installed them. According to the 'Readme', which comes with the installation I could choose between attaching the db to the Server or running a SQL script.
Neither works. I've read this link about remote connections (http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx). My development machine is just a local single computer and I still get this error message:
'An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact under the default settings SQL Server does not allow remote connections.'
I' ve opened TCP/IP and Named Pipes and I get the same result when trying to connect from the Server Explorer in VS.
Hello. I have a little problem . I have SQL Server Express 2005 installed on my machine. As well as SQL Server Management Studio. For some practice, I also installed the AdventureWorks sample database and attached it to the Server. When I open SQL Server Management Studio it's right there, in the Object Explorer, sitting nicely along with the master database and so on. Now, I have recently installed Visual C# Express 2008, in order to explore this exiting new thing called LINQ (Language Integrated Query) . To do so, I created a new Project (say, WPF or Console application), and once the project is up and running it would be nice to attach some data to it so we can query that data and learn about LINQ. There is a problem, however. On the main menu, I click on Data-Add new data source, choose Database, click on New Connection and the Add Connection window comes up. As a data source, I specify Microsoft SQL Server Database file. For a database file name, I navigate to MSSQL.1/Data and in that folder, there it is, the AdventureWorks file. Now, here is the rub. When I try to attach this file, I get a window telling me that I don't have permission to open this file! Contact the file owner or administrator! How about that?! Can anyone help? It would be very much appreciated! Thanks.
Hey, Everyone - I have downloaded two of the sample databases and get the following error when I attempt to open them:
Unable to open the physical file "c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAAssets_Maintenance_log.ldf". Operating system error 2: "2(The system cannot find the file specified.)". (Microsoft SQL Server, Error: 5120)
So what am I doing wrong? The install of these sample databases is simple and straight-forward.
I'm looking for sample database for data mining in SQL Server 2005. In my project I need to use all algorithms provided by SQL Server 2005. I know that we have "SQL Server 2005 Samples and Sample Databases" on microsoft.com site, but there are only AdventureWorks data sets. I need sth less popular, but similar.
I have found http://www.kdnuggets.com/datasets/index.html and others, but I don't see data sets good for multidimensional analysis.
The origin of data may be natural or artificial, it doesn't matter. I don't have to generate my own data, because I had to discover new knowledge, that will be surprising to me.
What are the AdventureWorksDBCI.ms and AdventureWorksBICI.msi used for? I try to run it, but it return the message "Another version of this product is already installed" and ask me remove the old version of this product. Anybody know what I should remove?
I have downloaded and run all the .msi's for the sample databases. To install them I am suppose to use "SQL Server 2005 Setup, you need to click the Advanced button....". I don't seem to have a "SQL Server 2005 Setup" - did the docs revert back to SQL Server rather than SQL Express or what ???
Hi, i read article on how to install the AdventureWorks on my PC, basically i downloaded the sample db from microsoft website, but after i install several times, i seems cant get to see it in my sql server 2005, please assist on this, i have been craking head for this. Thanks :)
please help me :( .. i m in very critical situation because of the following scenario.. we have been using sqlserver 2005 (evaluation version)and yesterday eval version expires ... now i have installed sqlserver 2005 (enterprise edition) on my server,i have all the mdf and ldf files for databases and also have full backup set of all dbs on server except system database. So now i want to reset server. So please help me in reinstalling all databases back to server with logins. i want to know abt the steps that lead me to successful re-installation of dbs. for your info .. i have all mdf & ldf files for dbs alonghwith backup set of dbs otherthen sys dbs ... please help me ..
Can't find anything on how to install to drives other than sys. I'm brand new to Servers and Databases in general and trying to learn. How do I get databases to install on drive partitions other than my main system drive?
Books online mention the existence of sample code for several custom tasks, including the one mentioned in the title. But, when I try to find this code in the location mentioned it is nowhere to be found.
I have run a search on the rest of my drive and come up empty.
Im trying to use VB.net 2005 to write a sample app to access a DB. Are there any samples for this and any samples of how I go about making the DB in the first place?
I installed the managerment stuid on my machine and now none of my database connections seem to work any more. I keep getting the attached error. Before I installed the studio the system worked fine, I could connect to the database and everything was fine. Does the studio change any permission stuff? I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database. I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is. When I look at the permissions inside of the studio it shows me that the connections should all be fine.
I checked and remote and local connections are setup, although it is only doing local connections anyway since this is a asp.net web server page.
Any idea what the problem is here? This is very frustrating and annoying :( Since I didn't change anything and now nothing I will do gets it to work. I even tried to uninstall the management tool and it still doesn't work. Cannot open user default database. Login failed. Login failed for user 'GREENANDFLUFFYASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'GREENANDFLUFFYASPNET'.
I'd like to go through and document the databases I'm responsible for...it's probably a good practice and I'm sure there a several approaches to doing so.
Anybody have comments, recommendations, or possibly a nice word template that links everything up?
hello everyone, I have to document about four databases, has anyone got any specific format or tool for documenting a database? Any inputs would be very helpful regards, Harshal.
I am looking for good utilities that document MS SQL table schema, indexes, layouts etc. I am currently looking at SQL auditor, but this product does not give me table schema or any kind of device revisions. I recently was given several SQL servers that have not been documented in any way.
thanks
ps SQL auditor gets a B+ in my book. Let me know what you think
Right now I am looking for the query-code to delete a table (not only the rows, but all of it). Somebody could give me the code?
In general I am always looking for a place on the web, where all sql-server 2005 (express) query-functions are explained. Somebody knows the right place?
Can anyone advise me on what they regard as the best SQL Server documentation tool. I am currently looking at Redgate and ApexSQL products. Do any of you have experience with these or others? I need one that will document 2000 and 2005 databases.
When I view dependencies on a table I can see a view- so I go to views and copy the information. But when there is a trigger as a dependency- I cannot find where to go to view it.
Are triggers within stored procedures somewhere? Or do they have their own separate place somewhere?
The documentation saysISNUMERIC returns 1 when the input expression evaluates to a validinteger, floating point number, money or decimal type; otherwise itreturns 0. A return value of 1 guarantees that expression can beconverted to one of these numeric types.(Cut and pasted from books online)Yet the following, one of many, example shows this is not true.select isnumeric(char(9))select convert(int, char(9))-----------1(1 row(s) affected)Server: Msg 245, Level 16, State 1, Line 2Syntax error converting the varchar value '' to a column of data typeint.So, besides filtering every possible invalid character, how do youconvert dirty values without error. I am not concerned that I may loosepossibly valid values or convert suspect strings to 0 (zero). I justwant to run without raising an error
What is the best online documentation either on the Web or installedwithSQL Server that I could use to get started? I want to jump in andstartcreating tables, etc for applications.Also, what is the most recommended text for converting my DBAexperience from other database to SQL Server.ThanksBill.
According to the book I am reading at the moment, there's supposed to be an SSIS documentation that ships with the product. I had the software installed by the IT guys but nothing with it apart from the books on line.
Does any one know of specific documentation on this?
