SQL 7 Database Lost?? HELP!!
Jan 30, 2004
I really hope someone has an idea or two that they'd like to share. Here's the deal...I have a customer who has SQL 7 running on an NT 4 server. Under normal circumstances, our client software connects to a DB running on that server. They recently had to reboot the server and now all of the clients on the network can no longer connect to our database...they get an error message similar to this:
Error -2147467259: SQL Server does not exist or access denied.
Additional Info:
When logging into the server, the service manager shows a "green arrow" in the system tray so I'm assuming SQL is running.
They are running some form of replication to another identical server.
They recently had to replace some network equipment on that segment, but everyone can still ping the server by name and IP. Also, they can access the virtual website on that machine's IIS.
Nobody knows the SA password.
As a test, I tried logging in using one of our software's "internal" login/passwords, but still could not login.
As a test, I tried to create a DSN to connect to SQL using the "guest" account (which should exist) but the wizard wouldn't get past the screen where you provide the authentication info.
Anybody have any advice for me/us?
View 5 Replies
ADVERTISEMENT
Jul 26, 1999
My question has to do with the ability to recover a suspect database in the event that the transaction log device file becomes corrupt or is deleted.
Specifically, consider the case where a user database has it's data device on one hard disk and the log device file on a 2nd hard disk. The database is set to truncate log on checkpoint.
If the disk fails on which the log device file resides, the user database will be marked as suspect. Assume this disk is replaced and rebuilt from a tape backup, including the log device file (which was backed up to tape during off hours.)
Will SQL Server have any problems with this? Will database recovery have any problems with this (assuming the restored transaction log was empty)? Any other issues?
Thanks in advance!
View 2 Replies
View Related
Oct 4, 2007
Hello
I am creating a TABLE
CREATE TABLE [dbo].[TbTest](
[id_TbTest] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED ,
[Title] [varchar](100) NULL,
) ON [PRIMARY]
when looking at the Column Properties in MS Server Management Studio I get :
Identity Specification = Yes
(Is Identity) = Yes
Increment = 1
Seed = 1
now if I want to make a copy of that database, importing datas and tables
I get :
Identity Specification = No
(Is Identity) = No
How can I avoid this problem ? my application is not working anymore
ALTER TABLE [dbo].[TbTest] WITH NOCHECK ADD
CONSTRAINT [PK_TbTest] PRIMARY KEY CLUSTERED
(
[id_TbTest]
) ON [PRIMARY]
is not solving that problem
thank you
View 5 Replies
View Related
Feb 9, 2006
I used a DTS package to import data from one database to a new database (different servers) and it seemed to work fine with the exception that it lost all the passwords. I got one error telling me that for security reasons, it left all passwords NULL. Sure enough - they are now all blank.
Ideas - any good articles with quick fixes ???
Thanks a bunch - I am just getting into a lot of unusual problems this week.
Nancy
By the way - what happened to the SQL*Pass message boards ??? Nobody visits there now....
View 2 Replies
View Related
Oct 4, 2005
Hi.
I've following problem:
- Customer played with his logical drives in a CPQ smart array
- He played too much: he lost the drive with the LDF-File
- Now the SQL-Server is in a kind of wired mode; you can
start and stop it, but you cannot connect to (neiter 'sa' nor
any other user available before)
In fact the mode is not wired: what shall he do other when
most important file is missing... :o
- The problem for me now is:
> How can I get the Enterprise Manager or Query Analyzer
up and running again to start a restore?
PS: The restore is to be done from a tape-library running
Veritas Backup Exec + SQL-Agent
PPS: Error-log says (what I already know):
2005-10-04 17:18:02.69 spid11 Device activation error. The physical file name 'H:DEVLOG1DEVLOG1.ldf' may be incorrect.
Thanks in advance for assistance.
Regards,
Carsten Loeffler
View 8 Replies
View Related
Mar 6, 2000
I use detach/attach method to move database to a new SQL Server 7 on MSCS. The security information was lost in the new server. Database Access permission was gone and I failed to select it again because message showed the database role is already exist. The default databases were also posted incorrectly. Would you please to tell me how to fix this type of peoblem or let me know how to move the login info such as login id, password, database permisson to the new server which locates in a different machine.
Thank you very much.
Rich
View 3 Replies
View Related
Mar 3, 2005
Can anyone help me to recreate the .NDF file if it was lost and not restorable? I have a stored procedure written that will then help me rebuild all indexes on all tables, but I can't seem to figure out how to create the index file again so I can run it. I have tried index files from other databases to no avail. There is no backup to go to.
View 10 Replies
View Related
Mar 28, 2008
here is my error message wich can also be seen live at www.aspdoug.com/menu log in with user: doug pass: macromedia!
--------------------------------------------------------------------------------------------------------------------------------
Server Error in '/menu' Application.
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 that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) 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. SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): 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 that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +737554
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +421
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +133
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +68
[HttpException (0x80004005): Unable to connect to SQL Server database.]
System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +124
System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +86
System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +25
System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +397
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Below is my web.config file.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<?xml version="1.0"?><configuration>
<appSettings/>
<connectionStrings>
<add name="aspdougcomConnectionString" connectionString="Data Source=65.36.214.248;Initial Catalog=aspdougcom;Persist Security Info=True;User ID=*&^%$#@;Password=*&^%$#@"providerName="System.Data.SqlClient" /></connectionStrings>
<system.web><!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
Visual Basic options:
Set strict="true" to disallow all data type conversions
where data loss can occur.
Set explicit="true" to force declaration of all variables.-->
<compilation debug="false" strict="false" explicit="true"></compilation>
<pages><namespaces>
<clear /><add namespace="System" />
<add namespace="System.Collections" /><add namespace="System.Collections.Generic" />
<add namespace="System.Collections.Specialized" /><add namespace="System.Configuration" />
<add namespace="System.Text" /><add namespace="System.Text.RegularExpressions" />
<add namespace="System.Web" /><add namespace="System.Web.Caching" />
<add namespace="System.Web.SessionState" /><add namespace="System.Web.Security" />
<add namespace="System.Web.Profile" /><add namespace="System.Web.UI" />
<add namespace="System.Web.UI.WebControls" /><add namespace="System.Web.UI.WebControls.WebParts" />
<add namespace="System.Web.UI.HtmlControls" /></namespaces>
</pages>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user. -->
<authentication mode="Forms" />
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>-->
</system.web>
</configuration>
-------------------------------------------------------------------------------------------------------------------------
MY host told me that they do not support sqlexpress and to change it MySql 2005 or something. im using hostmysite.com builder plan.
View 1 Replies
View Related
Nov 8, 2015
I recently installed a trial version of Sql12k on my laptop. Since 1st of November I've been creating tables without problems (15) and different schemas.I would like to emphasize that both mdf and ldf files are allocated in my USB3 portable disk. is that a problems for Sql12K? SSMS had stuck just for 20 sec or so. Then, system itself kill the task. A huge surprise when I restarted again... all the databases including the last one.. without objects. I mean, user databases...
Where are my logins? Where are my tables and schemas? Jesus christ.Sql logs inform the following (in all the moment my USB hardisk was properly connected)
11/08/2015 16:00:30,spid19s,Unknown,The operating system returned error 21(El dispositivo no está listo.) to SQL Server during a read at offset 0x000000 00140000 in file 'f:enriccopia_de_bbbb.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency
[code]....
View 4 Replies
View Related
Mar 25, 2008
Hi everyone, I am trying to upgrade a 2000 DB to 2005 with SSIS Database Transfer.
I finally got it to work with an online transfer but the destination database has no primary keys, indexes or identity columns from the source DB.
What am I missing?
What other ways are there to upgrade a SS2000 DB to 2005?
Thank you.
View 4 Replies
View Related
Dec 3, 2007
Hi all,
In the last one and half years, I used the Northwind Database in SQL Server Management Studio Express (SSMSE) to learn the programming of SqlConnections, Data sources, Database Exploere, ADO.NET 2.0, etc. via VB 2005 Express.
The Northwind Database in my SSMSE got lost very often, but I was not aware of it. How can I know where the Northwind Database is used or processed by my VB 2005 Express projects that were the examples of some tutorial books or my trial projects? How can I release the Northwind Database back to my SSMSE from the VB 2005 Express projects? Please help and advise.
Thanks in advance,
Scott Chang
View 2 Replies
View Related
Aug 19, 1999
I need help ASAP!
For some reason, we lost a dozen of our tables with valuable data. could be a virus or something that cleared out our data.
The last backup we have is last night at 11PM. If we recover from that backup, all the users lose all of today's work!
Is there a way I can just roll back the transactions from today?????!
I'd really appreciate any help urgently
Joyce
View 1 Replies
View Related
Nov 15, 2005
Hi all......well ill try and explain what I dont understand :-(
I am completely new to SQL. I have downloaded SQL Server Express 2005. I guess I need to download another program now like SQL Query Analyaer so that I can query a database - can anyone recommend a free download that will do the job?? I had a play around with one that I downloaded but to be honest, I have no idea on how to get the two programs talking.
Is someone able to guide me through how to initially set up SQl Server and how to get evrything working??
Much appreciated :-)
Gavsta
View 1 Replies
View Related
Jan 17, 2008
I get multiples of one record. i dont want multiples. but i need to have all the records that are the latest and i dont know how. can you help me.
thanks
SELECT TOP 1 [sn].[WrkstaId]
,[sn].[Computer Model]
,[sn].[Serial Number]
,[sn].[Asset Tag]
,[sn].[Computer Type]
,[id].[Name]
,[id].[Domain]
,[id].[OS Name]
,[id].[OS Type]
,[id].[Last Logon User]
,[id].[Last Logon Domain]
,[id].[Client Date]
,[pu].[_id]
,[pu].[Month]
,[pu].[User]
FROM [Altiris].[dbo].[AeXInv_AeX_HW_Serial_Number] sn INNER JOIN [Altiris].[dbo].[AeXInv_AeX_AC_Identification] id
ON [sn].[WrkstaId]=[id].[WrkstaId]
INNER JOIN [Altiris].[dbo].[AeXInv_AeX_AC_Primary_User] pu
ON [sn].[WrkstaId]=[pu].[WrkstaId]
WHERE [sn].[WrkstaId]=(SELECT MAX([WrkstaId]) FROM [Altiris].[dbo].[AeXInv_AeX_HW_Serial_Number]
WHERE [Serial Number]='68659')
ORDER BY [pu].[_id] DESC
68659Latitude D62028LGGD1Data not accessiblePortableWL-28LGGD1AZCORPMicrosoft Windows 2000Professionaluswclh04AZCORP2008-01-16 17:20:37.000864649Januaryuswclh04
68659Latitude D62028LGGD1Data not accessiblePortableWL-28LGGD1AZCORPMicrosoft Windows 2000Professionaluswclh04AZCORP2008-01-16 17:20:37.000864648Decemberuswclh04
View 7 Replies
View Related
Apr 11, 2008
After much hard work and effort I finally got SQL Server downloaded and opened. I am at a lost since the "Dummies" books, SQL & SQL Servier 2005 Reporting Services, I have don't (I can't find or understand) explain what I am trying to do. I have been able to create a couple of table, but can't see them. I can see the queries but not the actual table unless I run a query. How can I open the table it self?
Would to import an Access table in the SQLEXPRESS but can't figure out how. Can I get some guidence?
Any help I can get would be helpful. Thank you in advance.
CarLost48
View 5 Replies
View Related
Jun 8, 2007
Hello,I am using visual studio express edition. I making a nice website that uses the ASPNETDB.MDF for all those cool asp 2.0 membership and roles stuff.. This uses a SQL express database. OK so far. I have tried and tried to get my website live so I can further test it, but I can't People have been helpful, escpecially Bruce from this forum. I need more than help I guess. I really need to get this website up. Can someone please tell me where I can go to hire someone who will talk me through this process. I am not a programmer, I am a hobbyist. I understand SQL to select and update my database, but I can't do the stuff I read in FAQ's. It seems to be written for professionals. I have tried 3 different hosting services none seem to work. Please someone send me a private msg. we can work out terms. I am sure with someone over the phone that knows sql express and visual web developer expres will have me up and running in a jiffy. I can send payment via paypal.Jason
View 1 Replies
View Related
Sep 18, 2007
This procedure is missing one importent piece is I need to have a customerID added to the invoice table. The CustomerID comes from another table called Customer_Invoice_cart. I don't know how to convert Customer_Invoice_Cart.CustomerID to a @CustomerID to add to the table. If there is anyone out there who is good at stored procedures (unlike me who is learning) could help me out. FYI I realy cannot get the CustomerID for the .aspx page, it is not called any where.
procedure [dbo].[InvoiceAdd]( @EmployeeID int, @CartID nvarchar(50), @OrderDate datetime, @OrderID int OUTPUT)AS
BEGIN TRAN AddInvoice
/* Create the Order header */
INSERT INTO invoice( employee_number, invoice_date)VALUES( @EmployeeID, @OrderDate)
SELECT
@OrderID = @@Identity /* Copy items from given shopping cart to OrdersDetail table for given OrderID*/
INSERT INTO invoice_books( invoiceID, ProductID, TaxID, Quanatity, UnitCost, UnitPrice )
SELECT @OrderID, Inventory_Invoice_Cart.InventoryID, Inventory_Invoice_Cart.TaxID, Inventory_Invoice_Cart.Quanity, products.UnitCost, products.UnitPrice FROM Inventory_Invoice_Cart INNER JOIN products ON Inventory_Invoice_Cart.InventoryID = products.ProductID
WHERE Invoice_CartID = @CartID
INSERT INTO invoice_books( invoiceID, ServiceID, Service_TaxID, Service_Quanatity, ServiceCost)
SELECT @OrderID, Service_Invoice_Cart.ServiceID, Service_Invoice_Cart.TaxID, Service_Invoice_Cart.Quanity, services.price_leval1FROM Service_Invoice_Cart INNER JOIN services ON Service_Invoice_Cart.ServiceID = services.serviceID
WHERE Invoice_CartID = @CartID
/* Removal of items from user's shopping cart will happen on the business layer*/EXEC Customer_Invoice_Cart_Empty @CartIDEXEC Inventory_Invoice_Cart_Empty @CartIDEXEC Service_Invoice_Cart_Empty @CartID
COMMIT TRAN AddInvoice
View 15 Replies
View Related
Aug 18, 2004
I used sql 2000 create a data base at home call 'Mysite' several months ago, there are about eight tables and 30 stored procedures. When I run my asp.net program at home yesterday, and found can't connect to database. The error as follow: "Cannot open database requested in login 'Mysite'. Login fails. Login failed for user 'MINGYANG-MSONXHASPNET'. "
When I open the database, very surpriced to found that my database was suspect and not any item inside it. The suspect database include CommunityStarterKit. But Northwind and pubs database still there?
What happen? Last week I just download new Norton antivirus software, does have any relationship with it? Does data really gone? How to solve this problem?
Please help me if you have these experience.
View 2 Replies
View Related
Dec 31, 2005
What is the quivalent of EM for SQLExpress2005? With the old SQL 2000 I used EM to manage tables, SPs and such. Now, I cannot even find the databases - I installed the Club Starter Kit and I want to view and modify some tables. How do I do that?
View 3 Replies
View Related
Jun 10, 2006
Hello all let me first start out by saying I suck at SQL. I can do quite a bit with ASP.NET but SQL Server is on area that has haunted me and I have finally decided to bite the bullet and figure this behamouth out.Well here is my first problem, which is the biggest reason I can't seem to understand SQL Server or dataases in general.To have a realtional database you set up tables with foriegn keys and primary keys referenceing the id's like product table has a product name and one of the columns is a user_id displaying the id number of the user in the user table. From what I can tell you are supposed to set up the user_id in the products table a foriegn key to the Primary Key in the user table. I may be totally wrong on this though.Now my biggest question is how do you retrive this information the proper way to get it ready to be displayed in a gridveiw or a datalist? I have been reading SQL Server 2005 for developers and reading online tutorials and it seems like they say you need to set up a relationship and because of the realtionship you don't need to do a join, but I never hear how to use the relationship at all.Please someone help I am so totally lost that i feel like i will never understand. I have spent the last week trying to figure this out and I guess I am just googleing this wrong completely or i am incompentent one of the two.Thank you.
View 1 Replies
View Related
May 8, 2001
Hello all,
My company took over a project that another company was building. The other company switched all the passwords for the system and the database right before they left. No one has the passwords to the system or the database. Is there a way I can dump the data, or re-mount the drives into a different machine and get the data? Or am I just screwed? I have physical access to the machine and I can do anything needed I just need this data asap!!
TIA
Sean Silvius
View 3 Replies
View Related
Nov 27, 2000
Hi, maybe someone has some clues to the following situation. Suppose from a SQL 7 database, only the log .ldf files are lost. All datafiles are present. Suppose there is no backup of this database. SQL Server will put the database in the SUSPECT status. The following question is very interesting to me: Can one recover from this situation??? I ask this, because when datafiles are lost, it's obvious that you have lost data, but since the transaction log files are a "bit special", I just wonder how one can survive such a situation.
I know that IF a database has only ONE log file associated with it, and this one log file gets lost, SQL Server will create on startup a new log file. But with multiple log files, it does not behave in this sympathic manner. Is there perhaps any way to recover (for example, an undocumented dbcc command or so) ?
I surely will appreciate any tip or suggestion !! Thanks!!!
View 1 Replies
View Related
Oct 22, 2000
We lost all the data we had in a table. We restored the db and the transaction log up to a point in time, but could still not recover the table. We eventually only do db restore without the transaction log. We recovered the data in the table in question, but lost all the data entered that particular day. Does any body have a solution or suggestion that can help? I will be greatly appreciated.
View 2 Replies
View Related
Mar 19, 1999
Hi,
I face a different behaviour between SQL Server 6.5 and 7.0 regarding
the global variable @@identity.
I insert a row into a table with an identity column. This table has
an insert trigger attached which performs another insert into a second table.
Now I seem to lose the identity value (@@identity is NULL).
Example:
Take the following 2 tables:
create table a
(aaintnot nullidentity,
bbintnot null
)
create table b
(bintnot null
)
go
Table a has a trigger attached:
create trigger a_trigger
on a
for insert
as
insert b
select aa
from inserted
go
After this I execute the following SQL statement:
insert a (bb) values (1)
select @@identity
On 6.5 I get the result:
------------------------------------------
1
On 7.0 I get:
------------------------------------------
(null)
Which means that outside the trigger I have lost my identity value.
This feature of Version 6.5 I usually use to maintain
event logs. Using a trigger hides this maintenance nicely from the
application.
My question is now, is this a new feature of Version 7.0 or is it a bug?
BTW: The books online describe this behaviour in the case when the trigger
inserts value into a table with an identity property, which is not the case
in my example.
Regards
Marco
Marco Ruggli
ruggli_m@simultan.ch
Simultan P&I
Kantonsstrasse 1
6246 Altishofen, Switzerland
View 1 Replies
View Related
Aug 30, 1999
templog2.DAT and templog3.DAT were deleteed and now sql wont start. how do I recreate them with out a backup do I have any options? I will continue to monitor this site while I work on it. Please help.
View 1 Replies
View Related
Nov 7, 2007
I lost my datafile , that's corrupted and I don't have database backup. Any idea ?:(
View 1 Replies
View Related
Jul 14, 1998
Hi All,
I have lost the system administrator password for my test server which contains
inf. which I cannot afford to loose. The SQL server documents state that if
the password is lost , then a SQL re-installation will have to be done.
Is anyone aware of a way to reset the password for SA without reinstalling the
SQL server.
Matter is most URGENT.
Regards
Vedanth
View 5 Replies
View Related
Jun 18, 2006
Hey every one...I'm new here, and I feel rather bad just jumping in with out at least formally saying hi. However, I have a problem that I'm struggling with that I'm not finding an answer to via searches or through my library of books.
I'm sure it's basic, but I'm still new to the world of MS SQL, so please allow my naivety to MS SQL be forgiven.
I've been using MS SQL 2000 and 2005 on a Windows 2003 machine. However, I've been needing to be more mobile, I've been transferring some projects over to an XP pro lap top. There was a mild learning curve with .net with II5, because I've gotten spoiled with II6. However, that's fine.
It's just that when going through the procedure of attaching my databases from my Windows 2003 machine to my XP machine, I'm no longer able to log in, even though I've changed all the Connection string information.
On one database, it's not allowing me to use a stored procedure:
EXECUTE permission denied on object 'ViewSubscriptions', database 'la_market', schema 'dbo'
I know of general information concerning Owners of Databases and what not. However, when I tried to fiddle with granting dbo ownership (which i though DBO was just a general all purpose owner), it gave me other errors.
And on the other Database I'm getting absolutely no access to it what so ever (Once again, I've changed my connection string and everything)
Cannot open database "catalog" requested by the login. The login failed.
Login failed for user 'BUCKYCOREASPNET'.
Now, the problem isn't what I'm showing you here. Normally I have what it takes to find answers to these sort of problems. But with this one, I can't seem to phrase the problem correctly. So, advice would be wonderful. However, just phrasing the problem is good enough. So far I was told that my databases aren't mapped to my current Windows authentication. So, once again, just having some advice as to how to understand the problem will help. I may be new, but I'm enthusiastic and confident.
Thanks to any and all who may help...
View 1 Replies
View Related
Feb 6, 2006
I have lost LOG file, and I can not open database, (Error 5105) enterprise manager can not create database is it possible to not rewrite database ??
br
View 1 Replies
View Related
Feb 5, 2007
Hey everyone,
I've run into a fairly big problem. Apparently, the automatic backup has not been working since September, and that backup is of no use to me.
What I'm trying to do is restore the database without using the transaction log file. I don't care about a dirty database or lost data. The data is all I need, and the database structure of course.
I've tried several things.
Right click on the <database> go to tasks->attach-> pick MDF file etc.
Following this guide The only problem is I get a different error message. It doesn't ask a yes no question it just says the file doesn't exist and it can't create the database.
I've tried running it from other SQL management software and removing the LOG file when attaching, and that doesn't work. I tried:
Code:
MS SQL
EXEC sp_detach_db @dbname = <my db name>
EXEC sp_attach_single_file_db @dbname = <my db name>, @physname = <my db mdf file>
and I get the same message pretty much.
I tried this but I can't seem to get the database into emergency mode.
Am at the end of my rope and I really need this up and running ASAP.
Although I'm not sure of the proper syntax for setting a database into emergency mode, I think the last link I provided might do the trick.
I also tried the following:
http://www.spaceprogram.com/knowled...file-on_12.html
But when I get to step 8, the database is not in a suspect mode. When I click on it it says the database is in accessible.
When I right click and click on properties I get:
Quote:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Database 'BridgeTrak_Central2' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0194&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I checked the server and there is enough memory and disk space, about 2GB on each drive. Should be plenty for my 32MB database.
It's not my neck on the line but I would like to see my coworker stay here.
If anyone here knows anything about this, that would be great.
MS SQL 2000
Windows Server 2000 SP 4
_Any_ help or suggestions, other than the obvious, make sure backups are working, will be greatly appreciated....
Did I mention greatly appreciated?
I think the issue is that the original database was lost when someone else was trying what I'm trying now. They're very delete happy.
I think they may be SOL... glad it's not me, then again I wouldn't use the delete key without making 100% sure it wouldn't screw things up...I especially wouldn't empty the recycling bin. I probably would have deleted a database already burnt to CD, or burned some to CD....or made sure my backups were working. Messy messy network state, last guy left it in a mess. New network/DBA/ if it's got a network cable attached you're responsible. :S I don't like this new company that much. Too stingy... Dual P2 server?!?!?! Isn't that like, antiquated? No wonder there have been 3 dba/network admins/"if it's got a network cable..." that have left in the past year.
View 1 Replies
View Related
Jun 28, 2004
Hie,
do you know how can i find a lost user password with the sa connection.
What is the difference between the connection and the user ?
View 2 Replies
View Related
Jul 6, 2004
Hi,
I'm using SQL Server 7. I created an insert trigger on a table, and it is working correctly. But how do I now edit it in enterprise manager?
If I right-click on the table, all tasks, manage triggers, all I get is <new> in the name dropdown at the top. Why isn't my trigger there?!?
I must be doing something stupid... I'd appreciate it if someone pointed it out because I don't get it!
:confused: Rob
View 3 Replies
View Related
Jul 19, 2004
I am looking thru SQL Books, browsing the forum, but still unclear of the best method to perform the following calculation. I am really struggling with this and any helpful hints would be greatly appreciated.
Situation
Table 1 = customer information. Contains customer #, name, address, etc.
Table 2 = default price list. Contains item #, item desc, price
Table 3 = Allowed discounts based on customer types. Hospital gets $1 off, Doctors get 25 cents off, individuals get no discount.
Further discounts are given for multiple purchases. The 1st item is 100%, 2nd item is 75% and 3rd and subsequent items get 50% off purchase that day.
Here is a basic query result set of customer number, price, item ordered, item description and customer type.
Cust Price ItemNo Item Type
1 $5.50 23432 Moisturizer Hospital
2 $5.55 23453 Moisturizer 2 Indvidual
2 $29.00 23243 Lotion Pkg Indvidual
3 $29.00 23243 Lotion Pkg Doctor
3 $21.25 23232 Gloves Doctor
3 $3.00 23235 Drape Doctor
3 $2.00 27821 Lube Doctor
Calculation
Customer 1 ordered 1 item @ 5.50, but because they are a hospital they get a $1.00 discount. They only ordered 1 item so they pay 100% of the discounted price.
(5.50 - 1.00) * 100% = 4.50
Customer 2 ordered 2 items @ 5.55 and 29.00 respectively. They get no discount because they are an individual client, but do qualify for the multiple item discount of 25% for the second item.
29.00 + 5.55 * 75% = $33.16
Customer 3 ordered 4 items @ 29.00, 21.25, 2.00 and 3.00 respectively. They get a 25 cent discount off each item for being a doctor. They also get a multiple item discount of 25% off the second item and and 50% off items 3 and 4.
The math ideally will look like this
(29.00 - .25)*100% + (21.25 - .25)*75% + (3.00-.25)*50% + (2.00 - .25) * 50% = $47
Problem
For customer 2 if someone entered the lower valued item first the math would look like this
5.55 + 29.00 * 75% = $27.30 (loss of revenue)
Possible Solution
The prices need to be sorted in descending order to maximize revenue prior to discounts being taken for a given day.
Should I use a "rank by clause" statement?
Then I need to multiply the first item by 100%, the 2nd by 75% and the remaining items by 50% to get a grand total of money due. Any pointers would be greatly appreciated.
I am not at all sure how to accomplish this.
View 3 Replies
View Related
