Unable To Open .sql Files In Windows 98

Oct 31, 2001

Hi everbody,

In my machine i am unable to open .sql files. I am trying to open . Sql files it gives error message
Windows can't find program.exe. This program is needed for openings files of type"SQL script file"

Any body tell me which file i have to install.
Thanks

View 2 Replies


ADVERTISEMENT

Unable To Open Windows Service Identity Panel In Reporting Services Configuration Manager

Jul 4, 2007

Hi,



I've a slight problem with configuring my Report Server. I have set up everything apart from the initialisation and and the Windows Service Identity, however when I select the panel for the latter I am presented with a message box displaying the following:



" Reporting Services Configuration Manager:



There was an error while switching panels. The most likely cause is an error retreiving WMI properties. The exception details are:



InvalidArgument=Value of '1' is not valid for 'SelectedIndex'.

Parameter name: SelectedIndex "



I have tried re-installing the entire SQL server setup and this made no difference, I followed this by removing then reinstalling just the Report Service. Still nothing.



Any ideas as to what it is doing and how I should go about fixing it?



Sim

View 4 Replies View Related

Unable To Open The Physical File Test.mdf. Operating System Error 5 :on Windows Vista.

Aug 25, 2007

Hello,

We are trying to attach a database in Sql Server 2005 Express on Windows Vista.It will Show the following Error.

"Unable to open the physical file "Test.mdf". Operating system error 5 :". And then we installed the SQL Server 2005 Service pack 2. This error again comes.Could you please give me the steps to resolve the problem.

Thanks,

Mahesh



View 2 Replies View Related

Unable To Open New Query Window Or Open Any Table

Nov 3, 2014

Post installation of SQL Server 2014 Express edition, I am able to connect to the Database Instance.

But while opening a new query window in SSMS or opening a table getting the error:

Package 'RadLangSvc.Package, RadLangSvc, Version 12.0.0.0, Culture=Neutral, Public Token=89845dcd8080cc91' failed to load

Object reference not set to an instance of an object. (mscorlib)..Have already tried installing the componentsDACProjectSystemSetup_enu.msi, TSql LanguageService_enu.msi, DACFramework_enu.msi from path VS 2010 WCU DAC.

View 5 Replies View Related

How To Open SDF File Stored On Windows Mobile Device From A Windows Desktop App?

Apr 14, 2008

Long story short -

Have two C# applications - one WinForms desktop app, the other a WinForms smart device app. Both use SQL Server Compact CE 3.5 to store data locally. Both work just fine.

Now the desktop app needs to open and update the .SDF file that is stored on the Windows Mobile device. (Device will be docked via USB.)

What format would the path to the .SDF look like that the WinForms application would need to specify in order to open it?

Thanks for reading.

View 3 Replies View Related

Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...

Mar 26, 2008

Hallo there,

I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.

My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.

I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress

But nothing happens!

Please i am very desperate, any information will be gratefully accepted.

This is my installation Information



Code Snippet

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001


Thank you in advance,
Patonios


View 3 Replies View Related

Unable To Open A DTS With An FTP Step. Help!

Feb 15, 2008

Hi all. I'm currently working with SQL Server 2K, and I've installed Analysis Services as well as SP4.

I previously wrote a DTS that had several FTP steps in it. I was able to view/edit/run this package until recently. We were testing out SQL Server '05, and when we uninstalled it, it really screwed up my install of SQL 2k.

Long story short, I've scrubbed the system and reinstalled SQL Server 2K, but am unable to open the DTS package. The error I get is:

Error Source: Microsoft Data Transformation Service (DTS) Package
Error Description: Unspecified Error

Then a prompt that says:
The selected package cannot be opened. The DTS Designer has been closed

I've googled like crazy, and have been unable to find any resolution on this. Any help would be greatly appreciated!

View 5 Replies View Related

UNable To Open Any Table. Please Help Me

Apr 15, 2004

i have installed Microsoft SQL server 2000(evaluated version). I opened enterprise manager.and opened one of the default database.(Northwind).I clikced on the tables in the Northwind. On the right side of the console I right-clicked on one of the table and tried to open table--> Return all rows.. I am getting a message saying that "Provider cannot be found. It may not be properly installed".
I tried to reinstall the sql server evaluated version. I installed it 3 to 4 times restarting my computer. But still its giving me the same problem.
I am using Windows Xp OS. Do I need to take care of anything before installation. I even removed Office XP from my system thinking if that has anything to do with the installation. Please let me know as soon as possible.
One last question, is this a very rare problem or is the problem only with me. Because I couldnt find a solution as nobody is giving me a reply.

View 3 Replies View Related

Unable To Open The Physical File.....

Apr 7, 2006

Hi, i'm trying to interface a c# application with an sql database created with Visual Web Developer Express.
I have published the site (and the db) on iis 5 (xp pro).
Everithing goes fine on accessing the database from internet,but when i try to connect the db while it's opened with my c# program  i keep an error in the sqlconnection open command:
Unable to open the physical file "C:myApp_Datamydb.mdf". Operating system error 32: "32(The file is in use by another process.)".
My connection string from webconfig:
<add name="MYDBCS" connectionString="Data Source=.SQLEXPRESS;Database=&quot;C:myApp_Datamydb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
.....and  the connection string for the c# program:
"Data Source=.\SQLEXPRESS;Database=c:myapp_datamydb.mdf;Integrated Security=False;Connect Timeout=30;User ID=abc;Password=abc;Trusted_Connection=False;";
I have used a user to connect the database because there was a conflict trying to open the db with Integrated Security=True.
 
Does anyone have an idea where is the error?
Many  thanks
Max

View 1 Replies View Related

Unable To Open Tables In SQL7.0!

Jun 18, 2002

Hi All,
When i try to open tables under any database i get an error message that says
" An unexpected error happened during this operation. [Query] Query designer encountered a Query error: Unspecified error".
I uninstalled the Client from my desktop and reinstalled the client.When i try the same operation on the server where the SQL server is installed, i get the same error message.
I have sp2 installed.Would it help if i install sp3?

TIA
Muthu

View 3 Replies View Related

Table Columns Unable To Open

Mar 26, 2007

hi
i am unable to open table columns. kindly suggest. errcoe 233

reg
ramu

View 2 Replies View Related

MDX Error - Unable To Open Cellset

Dec 18, 2007

Hopefully I am in the right forum :o

I am trying to run the following mdx query:

SELECT
{
([Location].[Code],
[Measures].Quantity)
}
ON COLUMNS,
{FILTER (
CROSSJOIN (
[Manufacturer].MEMBERS, [Item].MEMBERS),
(([Measures].[Quantity]) <> 0))} ON ROWS
FROM
[Stockbalance]

But, I have encountered the error:
Unable to open cellset
Formula error - cannot bind: unknown dimension or member: "[Location].[Code]"

This is my first query using mdx. -_-' Appreciate if someone could help me out.:beer:

Also, what I am hoping to do:

Location1 Location2
Manufacturer Item Desc Qty Qty

View 1 Replies View Related

Unable To Open Configuration Manager

Dec 27, 2013

I am getting this error when i clicked on configuration manager. "Cannot connect to WMI provider. You do not have permissions or the server is unreachable. Note that you can only manage SQL server 2005 and later servers with configuration manager only."

View 10 Replies View Related

Unable To Open The Event Log Error

May 18, 2007

I got this error message from the sql agent log file:

05/18/2007 02:14:10,,Error,,,,,,[LOG] Unable to read local eventlog (reason: The parameter is incorrect),,,,,,,

How to solve this problem?



Thanks



April

View 3 Replies View Related

Unable To Open Physical File ...

Apr 24, 2008

Using SQL Server 2005 Express SP2.

Scenario : I have VC++ 2005 Express IDE open and use the database explorer to browse tables in a database. Then I open SQL Server Managament Studio Express and try to browse the same database. I get "Unable to open the physical file ... The process cannot access the file because it is being used by another process".

What is this "other process" that is trying to open the file? I thought the whole point of a database server was that clients talk to the server, and the server accesses the physical file. So only one process should be accessing the file. Do VC++ IDE and SSMSE work directly with the physical file, or do they channel their requests, etc. through the server.


Or is it something completly different?

Thanks,
Russel Dirks

View 4 Replies View Related

Unable To Open MSDB Node

Dec 20, 2005

I'm sure there is a simple answer to this but it eludes me at the moment.


I€™m using the Developer Edition of SQL Server 2005.





The MSDB node under Integration Services->Stored Packages refuses to open.


It always fails with a login timeout message and that the connection was


actively refused.





I€™ve run the SQL Server Surface Area Configuration tool and allowed remote


and local access, even though it€™s all installed on the local machine. This


didn€™t help.





The next thing I did was to turn off all my firewalls and internet access


control software and it€™s still not working.





I€™m using integrated authentication and the user is part of the


administrators group,


any ideas how I can try and rectify this?








Thanks


Paul

View 18 Replies View Related

Unable To Open DTS Packages Anymore

Nov 10, 2006

Hi,

I installed the dts designer component for 2005 so I could migrate over some 2000 packages and was able to successfully open and run dts packages under 2005.

Then all of a sudden I get this error msg and can't open them, migrate them, export them, etc:

"here were errors loading the package "MyPackageName":
[DNETLIB][ConnectionOpen (Invalid Instance()).] Invalid connection.
(Microsoft.SqlServer.DtsObjectExporerUI)"

That is not a typo, it actually says "here were errors..." instead of "There were errors..."

I've tried the obvious, repair the dts designer component and rebooting, no luck.

Anybody seen this?

Hope this is the right group to post to...

Thx

View 5 Replies View Related

Unable Open DTS Packages In SQL2k5

Jun 6, 2006

Hi,

I created DTS packages in SQL 2k and I want to access them (modify) in SQL 2k5.

But I could not open those in SQL 2k5. Is there any way to open them in SQL 2k5

Thanks,

Geetha

View 1 Replies View Related

SQL Management Studio - Unable To Open 3.5 CE DBs

Nov 23, 2007

Hi there

I have a VS2008 project with a CE3.5 database. I am unable to open this database within SQL 2005 Management Studio only VS2008. Any way of updating the CE engine for Management Studio?

"You are trying to access an older version of a SQL Server Compact Edition database (this is lying I know the db is 3.5+)"

[Db version 3505053, Requested version=3004180]

Thanks



View 4 Replies View Related

Help - Error: Unable To Open The Physical File

May 17, 2007

Hi, I've just finished creating my first ASP.NET website. I created it on my laptop and it works perfectly, but I'm having some problems deploying it to my web server (PC).The site works ok, but when I try to log in to my client area, I get this error:
"Unable to open the physical file "c:inetpubwwwrootONeillStrataApp_Dataaspnetdb.mdf". Operating system error 5: "5(Access is denied.)".An attempt to attach an auto-named database for file c:inetpubwwwrootONeillStrataApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I've searched far and wide for a solution and have read many articles, but none seem to be able to fix my problem. I've tried using that SEUtil tool, but that didn't work, I've made sure the App_Data directory on the web server isn't read only (the read-only checkbox isn't ticked, but it DOES have that little green square which I can't get rid of), I've assigned the ASPNET user as a db owner and that didn't work and I've manually attached the database to the web server's instance of SQL Express 2005.When I launch the solution in VS2005 on the web server, I can browse through the database and see the tables and data etc, but when I try to run the application, I get that message above...
Surely it shouldn't be this hard to get it going?Any help would be massively appreciated.

View 2 Replies View Related

Unable To Open SQL Server Express Database

Aug 19, 2007

Hello,
I have a SQL Express database in a C# project, which I use for unit tests.  However, I am getting the "unable to open SQL Express database", access is denied.  I used to be able to do use it fine.
I also used to attach it to the SQL Server engine, but now I'm getting access denied there as well.  I ensured that it isn't currently attached...  at least, I cannot see it, but maybe its still attached somehow?
I don't know what the problem is... running out of ideas.
Thanks.

View 6 Replies View Related

Enterprise Manager - Unable To Open A Table

Jul 26, 2001

After having installed my software at customer's I found out that it's impossible to open tables from Enteprise Manager (Query Designer error). I'm not sure it's because of my soft, but my clients are quite annoyed.
I have had this situation on my own server , and the only thing I could do was to reinstall the server.
Any other ideas? And what is the origin for this error?

Thanks in advance,

Asnate

View 2 Replies View Related

Unable To Open Step Output File

Aug 27, 2013

I am running sql script inside job.But sql is not saving the results in the file which i specified ('Unable to open Step output file'). I tried same thing on different server, it works fine.

Both are are 2008 R2. Is there any server level setting that i have to look at.On both servers i logged in as sa.

Why is it working on server1 ,but not on server2?

View 2 Replies View Related

Unable To Open BCP Host Data-file

Feb 13, 2007

I am having trouble with BCP. I get the same error with xp_cmdshell as I do with entering bcp as a DOS command. I have checked and rechecked the file names and permissions and even restart the PC.

Does BCP even work when SQL Server 2005 Express on a PC?

declare @sql varchar(8000)
select @sql = 'bcp SYMITAR..ACCOUNT in C: estEXTRACT.ACCOUNT -T -f C: estACCOUNT.FMT -S'+@@servername
exec SYMITAR..xp_cmdshell @sql
GO

Volume in drive C has no label.
Volume Serial Number is 08E5-2414

Directory of C: est

02/13/2007 08:44 AM <DIR> .
02/13/2007 08:44 AM <DIR> ..
08/31/2006 09:11 AM 27,503,161 EXTRACT.ACCOUNT
08/31/2006 09:12 AM 6,879 FMT.ACCOUNT
02/07/2007 08:46 AM 220 ACCTTYPE.FMT
02/13/2007 08:44 AM 0 filelisting.txt
02/07/2007 08:33 AM 220 ACCTTYPE.xml
5 File(s) 27,510,480 bytes
2 Dir(s) 54,344,847,360 bytes free

Could the fact that it's actually pulling BCP from c:Program FilesMicrosoft SQL Server80Toolsinn be a problem? I know this because it doesn't recognize the -x extensionof the bcp command.

PATH:
%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;C:Program FilesCommon FilesGTK2.0in;C:Program FilesMicrosoft SQL Server80ToolsBINN;c:Program FilesMicrosoft SQL Server90Toolsinn;c:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssemblies;c:Program FilesMicrosoft SQL Server90DTSBinn;c:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE;C:Program FilesQuickTimeQTSystem

...

I added the c: est to the path and removed c:Program FilesMicrosoft
SQL Server80Toolsinn from the path. While it recognizes the -x
extension now it still gets the same error message:

SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file
NULL

View 11 Replies View Related

Unable To Open Connection String..please Help Urgent

May 28, 2007

Hi,



I get the follwowing error message when i click on sync on my PDA.



"Failure to open SQL Server with given connection string.[connectString = Datasource=DSP-WS-194SQLEXPRESS;Initial Catalog=EMS;Integrated Security = True]; Multiple-step OLE DB Operation generated errors. Check each OLE DB status value if available. No work was done."



I am trying to use RDA to synchronize my server database (SQL Server Express) and client database (SQL Compact Edition) on my PDA. I am also using the sqlcesa30.dll for my internet URL.



I hope someone can help me out here. Thanks

View 4 Replies View Related

Unable To Open MSDB Under Integration Services

Jan 21, 2008

When I open integration services on my SQL server, I can expand the File System folder fine, but when I try to expand the MSDB folder under stored package, I'm getting the following error: My SQL Server is setup to allow remote connections. What else could be causing this error on the server?

TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Login timeout expired
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.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Native Client)
------------------------------
BUTTONS:
OK
------------------------------

View 3 Replies View Related

Unable To Open Current Flg From SQL Server Logs

Apr 15, 2008



Hi all

Just now a BCK job failed I have only one way to find out the cause of failure fromLOG,but log file is not opening
what is the cause may be?

View 5 Replies View Related

Unable To Open BCP Host Data-file

May 10, 2007

Hello,



I have checked file names, and I have checked permissions on the files. I do not see any reason why the BCP should fail. Any ideas how I can debug this further?



Thanks

Tom

View 1 Replies View Related

Unable To Open Things With Stored Pro... In Their Name: Virus

Aug 15, 2007

I can't use the words "stored pro.." in file names, folder names, or internet searches. I also can't click on links with those words in them. (hence my above abbreviations) The application will close down. I'm putting hyphens between the letters in the hopes that if anyone answers this I will still be able to open it.

i.e., I have a folder on my harddrive called "stored pro---cedures" - I can't open it via any windows applications. I named a word document "stored pro----cedure" and it closed the second I typed it in. I can use "stored pro", but not the other, even if i put or remove spaces between the letters. Even if I type other letters at the beginning and the end, the application will close.

I tried to do a Google search on "windows update" and "stored pro..." but the explorer window closed.


Has anyone else had this problem?

View 4 Replies View Related

Unable To Open / Create SSIS Package

Mar 24, 2008

I am receiving the following error when attempting to create a new package in SSIS 2005. I have completeley re-installed, and even had our support folks re-image my pc, but no luck. Works fine on my laptop, and others are not having any issues.

Microsoft Visual Studio is unable to load this document:
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Any help would be greatly appreciated. Thanks, Bryan

View 6 Replies View Related

Numerous Windows Open During Debugging

Feb 20, 2007

Hello all

Im sure this is something minor that I am overlooking but for some reason when I go to debug my ssis package all these windows keep opening( callstack, watch1, watch2,watch3,breakpoints, etc) . I cant seem to find out how to disable these -- any suggestions? I dont remember actually setting these to run

thanks

kam

View 4 Replies View Related

SQL EXPRESS WOES!!! Unable To Open The Pysical File...

Jul 13, 2005

Well, I'm to the point of giving up.  If there was a 1-800 # that charged $400 /minute for support at this point I would pay it!  I have been developing an ASP.net 2.0 web application that basically has login security.  I have been struggling to get this thing to work.  On my local machine it works fine, but when I copy the code (including the ASPNETDB.mdf that is in the APP_Data directory) over to a web server, I get to the login screen but when I attempt to login I get an error.  I've tried using the SSEUTIL.exe and was unsuccessful.  At this point I don't even know where to start.  Can someone please help me???  The error is listed below: 
Server Error in '/' Application.


Unable to open the physical file "C:InetpubWIWebApp_Dataaspnetdb.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".Unable to open the physical file "C:InetpubWIWebApp_Dataaspnetdb_log.ldf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'.File activation failure. The physical file name "C:InetpubWIWebApp_Dataaspnetdb_log.ldf" may be incorrect.
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: Unable to open the physical file "C:InetpubWIWebApp_Dataaspnetdb.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".Unable to open the physical file "C:InetpubWIWebApp_Dataaspnetdb_log.ldf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'.File activation failure. The physical file name "C:InetpubWIWebApp_Dataaspnetdb_log.ldf" may be incorrect.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): Unable to open the physical file "C:InetpubWIWebApp_Dataaspnetdb.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
Unable to open the physical file "C:InetpubWIWebApp_Dataaspnetdb_log.ldf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
File activation failure. The physical file name "C:InetpubWIWebApp_Dataaspnetdb_log.ldf" may be incorrect.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +684835
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1751
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +32
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +601
System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +159
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +346
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +445
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +304
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +126
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +239
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved) +815
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +80
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +78
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +161
System.Web.UI.WebControls.Login.AttemptLogin() +94
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +134
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5670



Version Information: Microsoft .NET Framework Version:2.0.50215.44; ASP.NET Version:2.0.50215.44

View 11 Replies View Related

SQL Server 2008 :: Unable To Open Database File (MDF)

May 6, 2015

I have a SQL Server 2005 database file (a .mdf file) that I am trying to open in SQL Server Management Studio so I can add a field to a table, but I am unable to open the file. I can't say that I really understand how SQL Server handles these databases. I especially don't understand the "attaching" and "detaching" operations.

I am working in VB.Net 2008 now, but my background is with VB6 using the JET engine. It was just so straightforward using the JET engine, but seems so much more complicated with SQL Server. I am trying to use .mdf files the same way I used .mdb files. I want my application to find the database file, "attach to it", and let me manipulate it.

At one time I was able to open my database in Sql Server Management Studio and edit the design of the database. The application still works but I am no longer able to modify the database because I cannot attach to it in Management Studio.

Here is a big clue: the files are no longer in the special folder anymore, which is c:Program Files (x86)Microsoft SQL ServerMSSQL.2MSSQLDATA. I might have deleted the files, stupidly, thinking they were redundant. I still have the .mdf file (and the _log.ldf file) on my hard drive and the application can still open it, but when I try to use Management Studio to attach to the .mdf file, I get this error:

Microsoft SQL Server Management Studio Express

An error occurred when attaching the database(s). Click the hyperlink in the Message column for details.

here are the details:

Unable to open the physical file "c:Program Files (x86)Microsoft SQL ServerMSSQL.2MSSQLDATAHEALSExamsSQL.mdf". Operating system error 2: "2(The system cannot find the file specified.)". (.Net SqlClient Data Provider)

Indeed the file is not there, but why is Mgmt Studio looking there? Why doesn't it just open the file where it is? What can I do to get it back? I even copied the files to c:Program Files (x86)Microsoft SQL ServerMSSQL.2MSSQLDATA? I get the same error.

Here is another clue: In Management Studio, when I right-click Databases, and chose Attach, it brings up a dialog. There I click "Add" to get another dialog in which I will select a database, but before the dialog appears I get this error:

Locate Database Files - KURANT-WIN7SQLEXPRESS
C:UsersJason KurantDesktop
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved