Some of you may have read my thread a while back complaining about SQL Server 2005 not being able to install with some errors about assemblies installing due to admin rights or some other type of error.
View 2 RepliesRESOLVED RESOLVED RESOLVED
DOH! When I rebuilt the OS, I changed the data partition ID's, and didn't remember to change them in the connetion strings
Not great, but better than continuing to bang head against wall.
Would like to say to MS appreciators that the VS2005 reinstall actually went quite well, considering.
===========================================================================
I built an app, works fine. Had the development environment working fine (VS2005 (SP0) and SQL Server Express). It had been stable for months, no problem.
Then I had to reinstall XP Pro...(finally threw too many conflicting programs into it, I guess...)
I managed to get VS2005 reinstalled ok. However, when I opened and compiled my existing app in VS2005, using Cassini, I got the dreaded error:
An attempt to attach an auto-named database for file <file string> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I also get this error for the compiled copy of the app on the same machine, running on IIS. (Where it also previously worked fine).
The Connection strings are all of the form
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=(specific file string).MDF;Integrated Security=True;User Instance=True"
I appreciate that there are zillions of posts on this issue. I'm hoping that someone might know why this should happen in this particular case.
The thing that's different about this case is that the app was working fine; I have the app deployed on a demo machine and also on a remote server as well as on the development machine.
The only thing that changed is that there was this fresh install of SQL Server Express.
I tried using >> sp_configure user instances enabled','1';RECONFIGURE <<< in SSMSEE, which took, but didn't help.
So something is different in SSE. Since the app is stable everywhere else, I REALLY don't want to go through and adjust the connection strings...MUCH better to figure out what SSE needs to be happy with the existing connection strings...as it was before.
Any suggestions would be appreciated.
Thanks!
EDIT----TRIED SOME THINGS:
Changed folder and file permissions to allow ASPNET full access to the .mdf's and log files (though never had to do this before on the development machine.) No change...
Can see the table contents within the .mdf through SSMSE, and also through Server Explorer in VS2005.
So because the problem happens with both IIS and Cassini, I'm assuming it's got to be an issue between ASPNET and SSE.
EDIT --- TRIED SOME MORE THINGS:
I dimly remember that when I had this problem before, it was that the error message was too "dumb". It wasn't my file that had the permissions problems, it was that the SSE System Databases had to have permissions with respect to ASPNET.
I tried to set that up but I'm a complete newb on this area, so I don't know if I did it right. In SSMSE I created a Login for MyComputer/ASPNET, and gave it all permissions and roles, and then made it an owner for the four system databases...but no joy.
Any pointers on this last piece would be helpful.
EDIT - MORE INFO
The error details
[SqlException (0x80131904): An attempt to attach an auto-named database for file <filestring>.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
The programmers encountered a problem as following:
Different programmers use the same account(Admin) to login to the same database to create table from different workstation. The tables were created through the same steps which is highlighted the Table folder -->New table then go through the wizard. The table were created successfully but the ownership were different. One with Admin as owner, the other has dbo as owner. Even Admin is the owner of the database but this created a problem for them that they need to specify differently for the tables depend on who created them.
what is the cause of this, sevice pack 3 is installed on the machine.
Its Sql Server 7.0
Thanks in advance.
RSVP
hi, i have got 10 dts packages i want to create a job and put them all into that job. I could not execute the dts create in tsql. Can any one say as how to execute that in the job.
View 1 Replies View RelatedBabu.G here,
Working as MS-SQL DBA IN MNC..I HAVE A DOUBT SO PLEASE
CLARIFY THAT..WHERE SHOULD I DECLARE GLOBAL VARIABLES..FOR EXAMPLE @@ROWCOUNT AND MANY..
LIKE THAT I NEED TO DO..
IN CASE IF I AM DECLARING ONE @@GLOBAL VARIABLE IN PROC AND STORING SOME VALUES IN THAT
IF CALLED THAT VARIABLE INTO SOMEOTHER PROC ..IT IS GIVING ERROR..
PLEASE TELL ME..
BABU.G
Thanks in advance
hey people...
im currently using sql server 2000... is there a datatype or a way so
that you dont have to limit the length that a user can enter into a
textbox (for example) that will be saved in a column in a table in sql
server?
thanks!
I'm in deep problem...please help...
There was someone who got into the system and modified the database properties to DBO use only..what we want to do is to track such changes with when they did.
As like what happened earlier..some told me about turning the audit level to all will help but it does not give the information about who has did and what did they do...
Is there a way in which we can find out what happened and who did this what command they have executed...
Thanks..i appreciate your help..
Mitchell
Hello I have the following query set up and I am getting the errors of: Any help on this would be appreciated.
Thanks
Stuck !
Server: Msg 107, Level 16, State 3, Line 2
The column prefix 'TEAM3B_PULL_TOTAL_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 2
The column prefix 'BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 10
The column prefix 'TEAM3B_PULL_TOTAL_TST' does not match with a table name or alias name used in the query.
Server: Msg 107, Level 16, State 1, Line 10
The column prefix 'BUS_REQ_DESCRIPTION_TST' does not match with a table name or alias name used in the query.
Select REQUEST,BUSINESS_REQ_ID,TEST_CASE_SOURCE as SOURCE from TEAM3B_PULL_TOTAL_TST
if TEAM3B_PULL_TOTAL_TST.REQUEST<>BUS_REQ_DESCRIPTION_TST.REQUEST
begin
Insert into TEST_REPORT.dbo.BUS_REQ_DESCRIPTION_TST(request,bu siness_req_id,source)
select request,business_req_id,test_case_source as source
from TEAM3B_PULL_TOTAL_TST
end
Else
begin
if TEAM3B_PULL_TOTAL_TST.REQUEST=BUS_REQ_DESCRIPTION_ TST.REQUEST
begin
Insert into TEST_REPORT.dbo.RDD_UPDATE_TST(request,business_re q_id,test_case_id,test_case_descr)
select request,business_req_id,test_case_id,test_case_des cr from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST
order by TEAM3B_PULL_TOTAL_TST.REQUEST,TEAM3B_PULL_TOTAL_TS T.BUSINESS_REQ_ID,TEAM3B_PULL_TOTAL_TST.TEST_CASE_ ID
end
end
Hello,
When I try to run the following query:
if (select REQUEST from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST) Not In(select REQUEST from TEST_REPORT.dbo.REQUEST_BUS_REQ_TST)
begin
Insert into TEST_REPORT.dbo.REQUEST_BUS_REQ_TST (b.request,b.business_req_id,b.bus_test,b.test_cas e_id,b.test_case_source,b.test_case_descr)
select a.request,a.business_req_id,a.bus_test,a.test_case _id,a.test_case_source,a.test_case as test_case_description
from TEST_REPORT.dbo.TEAM3B_PULL_TOTAL_TST AS A INNER JOIN TEST_REPORT.dbo.REQUEST_BUS_REQ_TST AS B ON A.REQUEST = B.REQUEST
Order by REQUEST,BUSINESS_REQ_ID,TEST_CASE_ID
end
I am getting the error messages of:
Ambiguous column name 'REQUEST'.
Ambiguous column name 'BUSINESS_REQ_ID'.
Ambiguous column name 'TEST_CASE_ID'.
What is wrong in the above statement?
Thank you,
I am given to install ODBC drivers in two servers and main thing is they are clustered . SO do i have to install in both servers or CLuster will configure that. Urgent help please . Thanks
View 8 Replies View Relatedhi,
I am recently upgraded to sql 7.0, my clients are having 6.5 and 7.0 versions means we are still having some 65 servers.
When they try to connect to new 70 server it is saying ''login failed''.
I think it is trying to connect to old sql 65 version, what i have to do to connect to sql70 for clients..
They are having both 7.0 and 6.5 servers.
Can anyone pls assist me regarding this.
Thank u very much
--Ramu
Dear friends,
After installing visual interdev, on a webserver (nt4.0 ent server),
whenever I was trying to configure the DSN on the ODBC settings, It gives
" The ODBC resource DLL (C:WINNTSYSTEM32odbcint.dll)is a different
vaersion than the ODBC setup dll(c:winntsystem32odbccp32.dll)
you need to reinstall the ODBC components to ensure proper operation." error msg.
I thought of removing all the ODBC drivers and reinstlling the odbc drivers came with NT SERVER. I don't know how to do it. If anyone knows how to do it, can you please post it. Thanks a lot.
Hi all,
I have some problem :
I use sql server 2000,I have about 20000 records !
I delete all data unfortunately !
So , i need to restore all .
Are there way to do this ? I don't setup automatic backup !
My data is very important !
Thank you very much.
I tried SQL mirroring in beta 1 , then it was gone, until SP1.
Now I can not setup mirror, it is fine if it is just hard to setup, but it seems it is full of bug! The mirroring has to be stable, since I am trying to mirror product db, what a diaster if something goes wrong.
I am trying two servers, both has 9.0.3042. First I tried to setup on my home machine, I VPN to my network, After I config security, I see two connection strings:
TCP://sql8.mydomain.netsql2005:5022
TCP://sql5.mydomain.netsql2005:5022
and I click start mirroring, then I got error - Alter failed due to invalid connection string. Hard to figure it out, right?
Then I tried the same thing on a server in the network, this time I get
TCP://sql8.mydomain.net:5022
TCP://sql5.mydomain.net:5022
and it doesn't show that error anymore, I am not sure why the connection should be like the latter format, but in anyway, how come SMO can not make it right?
then I get another error, SQL server doesn't exist or can not access, I search on the Internet, it seems that error could mean anything, include that the mirror db is not in restore mode.
But I did set the mirror db in restore mode and both sql5 and sql8 are under same domain, pysically close.
So what else I can check?
Any suggestion?
thanks
A collegue from me used the MySQL database before (I haven't done this before). He asked me, if it is possible to store a MD5 hash in a cell.
He telled me that MySQL has got a special function wich computes the hash value. Can someone help me?
Thanks for help
Our SSIS package suddenly stopped loading. We have 64 bit server on which we run SSIS packages. We had problem "script task failed to load" so we started to use the 32-bit version of dtexec to run the packages. Package used to run fine.
Today we upgraded our server to Sp1 and 2153 hot fix (x64) and now the package have stopped to load.
we confirmed that the issue is not as inthe KB below:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B918038
We are still using the 32-bit version of DTExec(as in SQLx86). With 64 bit we get the error "script faield to load". we are going to fix the script failed to load error but, we need help to get going right now.
help would be greatly appreciated
Message:-
Executed as user: PHX\_IDSS-OPS. ... Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:13:48 AM Error: 2006-07-28 01:14:50.11 Code: 0xC0010018 Source: Description: Error loading value "<DTS:LogProvider xmlns:DTS="www.microsoft.com/SqlServer/Dts"><DTS:Property DTS:Name="ConfigString">AdCenterExtractionLog</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property><DTS:Property DTS:Name="ObjectName">SSIS log provider for Text f" from node "DTS:LogProvider". End Error Could not load package "D:adcenterDWApplicationBINACDWExtraction.dtsx" because of error 0xC0010014. Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails. Source: . The step failed.
Dear Friends,
I have a IIS 4.0 server ( configured as virtual multi servers), and a sql server containing multiple databases.
each virtual server should access a unique database on the sqlserver.
How can we configure this setup on both servers?
Note:the owner of each multi server (dbo)will own a unique database. they are bound to only with theirs database only.
Please help me on this issue?
Thank you all and Happy holidays!!!!!
Dear Friends,
I have a IIS 4.0 server ( configured as virtual multi servers), and a sql server containing multiple databases.
each virtual server should access a unique database on the sqlserver.
How can we configure this setup on both servers?
Note:the owner of each multi server (dbo)will own a unique database. they are bound to only with theirs database only.
Please help me on this issue?
Thank you all and Happy holidays!!!!!
I am having a problem getting into SQL 2005.
My connection string is as follows:
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection(@"Provider=SqlOleDb;Data Source=Orange;Initial Catalog=Test;");
//tried with taking out comma after Test as well.
I have tried a lot of different permutations here and I cannot get this to work.
Hi, I'm configuring a maintenance plan for my SQL Server 2005. Is the order of things important here? I can't seem to find any best practices for this anywhere.
Obscurr
hi,If we consider the following scenerio:a school with 500 students.On average student takes [x] courses per year, and [y] tests per course.table of grades:+------------+-----------+---------+-------+| student_id | course_id | term_id | grade |+------------+-----------+---------+-------+| | | | |+------------+-----------+---------+-------+| | | | |+------------+-----------+---------+-------+as average, x = 20, y =6 thennumber of records = 500 * 20 * 6 = 120,000 record per year.is this design correct considering number of records generated per year?Is it important to reduce the "number of records" or no?thank you.
View 1 Replies View RelatedThere are twelve more exams will retire on March 31st, 2009. Microsoft has announced this information. These exams focus on technologies will be no longer included in Microsoft mainstream support. The exams are currently required to achieve Microsoft Certified Application Developer (MCAD), Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Database Administrator (MCDBA) certifications.
Details:
Developer exams that retire on March 31, 2009
€˘ Exam 70-300: Analyzing Requirements and Defining Microsoft .NET Solution Architectures
€˘ Exam 70-301: Managing, Organizing, and Delivering IT Projects by Using Microsoft Solutions Framework 3.0
€˘ Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
€˘ Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
€˘ Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
€˘ Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
€˘ Exam 70-316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
€˘ Exam 70-320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework
€˘ Exam 70-330: Implementing Security for Applications with Microsoft Visual Basic .NET
€˘ Exam 70-340: Implementing Security for Applications with Microsoft Visual C# .NET
Microsoft SQL Server exams that retire on March 31, 2009
€˘ Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
€˘ Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
This article is quoted from microsoft.com.
We're developing a WinForm app that is being deployed via ClickOnce. The application will have the ability to import/export data with the intention of this being done via SSIS. When this app is deployed and run against SQL Express, the following error gets generated:
€śRetrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to error: 80040154€?.
Is SSIS functionality supported in SQL Express?
Hi everyone, I have a question. We need to create a server report to display a one product's information at the left (datasource with a one ID of selected product) and other products to compare at the right (second datasource with N of IDs of products to compare). The problem is how to duplicate the first List element with selected product on the every page (by default it renders only on the first page)? Any ideas?
View 3 Replies View RelatedHello everyone, I've been searching the forum for three hours now and I couldn't find anything that helped me.
First I thought I didn't install the SQL server properly, I now found out that it is installed properly.
I am using VWD 2008 Express Edition. I could access the aspnetdb in the SQLExpress server. I could modify entries and create new databases. So the server obviously works.
Problem -> I cannot access the WebSiteAdmin modul ... for no apparent reason, it always gives me a timeout.
If you restart the tool by clicking the asp.net icon in the traylist stop it, then retry over the button in the VWD, then I did that a dozen times. I restart the tool and then access it five seconds later, no matter what I do I always get a time out.
Any help is appreciated, I can't solve this and I really really need it. Thanks a lot in advance.
Hello All,
I am trying to perform a performance audit on a SQL Server where I am positive my most likely bottle neck is the disks. I assume the primary metrics I should be interested in are %Disk Activity and Disk Queue Length, right?
What are the actually guidelines for these metrics? Also, Are there other perf mons I should be running against the disks?
Thanks In Advance.
Ryan Hunt
I require to update sysxlogins table to include one more column into it in SQL 2000 sp4.
I am trying to develop a wrapper UI over sql security so that logins can created and modified right from my UI.
Doing this is very crucial for my current project.
Kindly help. Any help would be much appreciated.
Currently i have tried: sp_configure "allow updates", 1
reconfigure with override
I also tried giving -m switch in sql service parameters and restrating the service
but nothing works....
What is DAC. I am using queryanalyzer how can i use sqlcmd -a. ? cuz i am familiar with query analyzer only .Is that necessary to do as well ??
i attached adventure works in sql server 2008 and it showing as read only ,make it read write or remove read only tag from database.
View 11 Replies View RelatedHow to identify whether the files are in read write or read only?
View 1 Replies View RelatedI'm trying to do Sharepoint DR with Log Shipping and every thing configured except one thing which is switch the WSS_Content (Standby /Read-Only) DB to be ready and Write.Â
I tried from
GUI or ALTER DATABASEÂ [WSS_Content]Â SET
READ_WRITEÂ WITHÂ NO_WAIT
but I received the below error:Â
Database WSS_Content is in Warm StandbyÂ
I have two database files, one .mdf and one .ndf. The creator of these files has marked them readonly. I want to "attach" these files to a new database, but cannot do so because they are read-only. I get this message:
Server: Msg 3415, Level 16, State 2, Line 1
Database 'TestSprintLD2' is read-only or has read-only files and must be made writable before it can be upgraded.
What command(s) are needed to make these files read_write?
thanks
I am using a function to fill a listbox in asp.net If I run it using the sql statement in the code, it works. if I use the sp I get an error saying the sp expects @strBookingNo which wasn't supplied. I have stepped through the function and there is a value in txNewBookingNo.text. Here's my function - the part commented out is the part that works,but I'd rather do it through an sp. I've included my sp too
Function GetFacilitiesBookings()
Dim MySQL As String = "spRB_GetFacilitiesBookings"
Dim MyConn As New SqlConnection(strConn)
Dim Cmd As New SqlCommand(MySQL, MyConn)
Cmd.CommandType = CommandType.StoredProcedure
Cmd.Parameters.Add(New SqlParameter("@strBookingNo", CInt(Me.txtNewBookingNo.Text)))
Dim myDataAdapter As SqlDataAdapter = New SqlDataAdapter(MySQL, strConn)
Dim ddlDataSet As New DataSet
myDataAdapter.Fill(ddlDataSet, "tblRB_FacilitiesBookings")
Return ddlDataSet
'Dim strSQL As String
'strSQL = "Select * from tblRB_FacilitiesBookings where FB_BookingNo = " & CInt(Me.txtNewBookingNo.Text) & " and FB_Cancelled =0"
'Dim myDataAdapter As SqlDataAdapter = New SqlDataAdapter(strSQL, strConn)
'Dim ddlDataset As New DataSet
'ddlDataset.Clear()
'myDataAdapter.Fill(ddlDataset, "tblRB_FacilitiesBookings")
'Return ddlDataset
End Function
CREATE Procedure [spRB_GetFacilitiesBookings]
@intBookingNo integer
as
Select * from tblRB_FacilitiesBookings where
FB_BookingNo = @strBookingNo and
FB_Cancelled = 0
GO
Can anyone point me to a site which explains SQL syntax. ie I want to put brackets around a variable which holds a string of values for an IN clause.
Dim mySQLstr As String = "SELECT * from vweAvailableRooms where BD_RoomRef IN '"(" & Me.Session("RoomRefLogin") & ")"'"