Question about Computers & Internet

5 Answers

SQL 401: cannot open database

I had to move an ADP user to new PC after installing ADP user attempts logon error window "SQL 401: cannot open database"

WinXPpro, plenty of RAM and disk space on PC.

Posted by on

  • scrockern8r Apr 06, 2009

    I have the exect same problem

  • Dazy Parker
    Dazy Parker Sep 15, 2015

    attach your client sql.ini and server sql.ini if they are in a different machines. else attach sql.ini

×

5 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Welcome Back:

    Visited the website for 2 consecutive days.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 8 Answers

SQL database Recovery Software remove errors from SQL server database and allow recover your all database of SQL Server 2012 or below versions. The software support with all over version of SQL server. Try at here:-
SQL Database Recovery

Posted on Nov 08, 2014

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Social Spider:

    An expert who has shared 50 answers on their Facebook wall.

  • Expert
  • 43 Answers

It's an IIS issue on the directory security for the virtual folders or parent site.

Posted on Aug 07, 2015

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 3 Answers

I have provide a solution, i know about some other good tool for recovering and repairing corrupted SQL database, use Kernel for SQL repair software easily recover and repair .mdf file from SQL database. Link is here : http://www.sqldatabaserecovery.net

Posted on Jun 19, 2013

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Champion:

    An expert who has answered 200 questions.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 401 Answers

SQL Server is quite complicated program, which sometimes causes some problems for me. I suppose in this situation would be helpful the next program from a soft blog - repair mdf.

Posted on Apr 09, 2011

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 2,794 Answers

Sounds like a security issue with SQL server.

Check your SQL database connections. You will probably have to recreate them so that PC can have access to them.

Posted on Jun 10, 2008

  • Abel Martin
    Abel Martin Sep 05, 2014

    I have provide a good solution, i know about some other good application for recovering corrupted SQL server database, use third party SQL database repair software that can easily recover and repair all .mdf file from SQL database. To know more visit this site:http://recoverydatatools.com/sql-recover...

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

How do I recover data from .mdf file


Detach you database. Overwrite the mdf and ldf files you've restored from your backup with your files from the D: drive. Reattach the database.
There is no guarantee that this will work or if it works, that your database is in a state where you can continue to work with.
If that doesn't work then there is an option to try to restore database using SQL Server Recovery Toolbox. It is a powerful tool for data recovery. They have a demo version. So you can check it works in your situation or not.
http://www.oemailrecovery.com/sql_repair.html

Jan 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...

2 Answers

Attach a database without the corrupted log file


There might be other options out there. This is something that worked for me once but there are no guarantees that it will work at all times.

Stop SQL Server instance -> Copy MDF and LDF files to another location -> Delete original MDF and LDF files -> Start SQL Server instance again -> Create new database with exact same name and file names -> Stop SQL Server -> overwrite newly created MDF and LDF.

After this your database should be back online. If it is then go ahead and put it into EMERGANCY mode and SINGLE USER mode.

Finally go ahead and execute DBCC CHECKDB like this

DBCC CHECKDB (databaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

More information you can dig out from resources directly connected with SQL Server databases and database corruption in MS SQL Server any version...
http://itknowledgeexchange.techtarget.com/itanswers/how-to-restore-mdf-file-as-bakcup-databe/
https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox

May 15, 2015 | Microsoft SQL Server 2008 Enterprise Full...

2 Answers

How to Change SQL Server 2005/2008 User Password


There is one SQL password recovery tool, SQL Password Genius, which would help you to successfully change SQL Server 2005/2008/2012 user password instantly, especially when you couldn't think of other ways for it.

1. Open SQL Server Configuration Management and stop SQL Server Services.

2. Install SQL Password Genius full version and run it on computer.

3. Click "Open File" button to import master.mdf database file into this recovery tool.

4. Select user in list and click "Reset" button.
Instantly, new user password would be available for SQL Server logon after you type new password for user.

Now, SQL Server user password has been changed and you can login into SAL server now. But please remember to restart SQL Server Services before you access to SQL Server with user password.

Jul 04, 2014 | Microsoft SQL Server 2008 Enterprise Full...

3 Answers

Forgot SQL Server SA password. How to reset user password to login SQL Server?


When SA password for SQL Server logon forgot, please take SQL Password Genius to install it on computer.

Step 1: Run SQL Password Genius full version and browse Master.mdf file to import into it.

Step 2: Select SA user and click "Reset" button.
After master database file imported into SQL Password Genius, you would see all user in list. SA password is unknown. Select SA account and click "Reset" button.

A new window would pop up, type new password for SA account in it. And click "OK". Instantly, SA password is changed successfully. SA password lists in software screen.

Step 3: Close SQL Password Genius and restart SQL Server Services.

SQL Server services influence SQL password reset on computer. So we stop it before using SQL Password Genius. Now, when you finish SQL SA password reset, restart SQL Server Services to run SQL Server with SA account.

How to Reset SA and Other User Passwords for SQL Server

Jun 27, 2014 | Microsoft SQL Server 2005 Enterprise...

1 Answer

What is the extension file name for a microsoft access file?


According to Wikipedia:-

Access Project .adp
Access Blank Project Template .adn
Access Database (2007) .accdb
Access Database Runtime (2007) .accdr
Access Database Template (2007) .accdt
Access Database (2003 and earlier) .mdb
Access Database, used for addins (2,95,97), previously used for workgroups (2). .mda
Access Database Template (2003 and earlier) .mdt
Access Workgroup, database for user-level security. .mdw
Access (SQL Server) detached database (2000) .mdf
Protected Access Database, with compiled VBA (2003 and earlier) .mde
Protected Access Database, with compiled VBA (2007) .accde
Windows Shortcut: Access Macro .mam
Windows Shortcut: Access Query .maq
Windows Shortcut: Access Report .mar
Windows Shortcut: Access Table .mat
Windows Shortcut: Access Form .maf

Jun 03, 2010 | Microsoft Office Access 2003 (077-02871)...

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is showing CREATE TABLE...


Hi,

Before you create a table you need to:-

1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database

you can then create a table and use the database

Please post if you do not know how to do this and i'll give you some links

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

TRIGGER IN SQL


A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. A trigger is really an event handler. SQL Server allows users to create triggers (event handlers) for 3 types of events:
  • DML Event - Occurs when a DML (Data Manipulation Language) statement: INSERT, UPDATE or DELETE, is executed.
  • DDL Event - Occurs when a DDL (Data Definition Language) statement: CREATE, ALTER, or DROP, is executed.
  • Logon Event - Occurs when a user logins to the Server.
There are 3 different types of triggers (event handlers) based on the types of events they are triggered by:
  • DML Trigger - Executes in response to a DML event.
  • DDL Trigger - Executes in response to a DDL event.
  • Logon Trigger - Executes in response to a logon event.

Jul 03, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

SQL Server 2000


An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.

1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.

If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)

That should move your stored procedures and user defined functions over.

You can use a similar process to move tables, views, users, and other objects over as well.

Jan 17, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

4,883 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98816 Answers

David Payne
David Payne

Level 3 Expert

14071 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...