.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

sql connection in offline mode(offline attaching)

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
 

hi i use this sql connection please help me to repair it

datasource=.\\SQLEXPRESS;AttacHDBFileName=|DataDictory|\\DBfileName.mdf:Integrated security=true:connect Timeout=30;User Instance=True;Trusted_Connection=Yes|





View Complete Post


More Related Resource Links

Is realtime SQL Server Replicated database usable realtime (not offline / single user mode)

  

Is SQL Server replicated (destination) database replicated by SQL Server Replication fully usable? Meaning it's not just for Disaster Recovery but is fully usable from various say BI / Reporting purposes.

In the essence it is exactly same as other replication engines and the destination database is very much usable and not just offline / single user mode.

Thanks

 


SQL SERver 2000 database is in offline\suspect\Emergency mode

  

Hi,

I m having sql server 2000 database and 4-5 database is in offline\suspect\Emergency .

I have tried that to take online throgh following step:

EXEC sp_resetstatus 'DBName'

GO
ALTER DATABASE DBName SET EMERGENCY
DBCC checkdb('DBname')
ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DBName')

 

 

2. ALTER DATABASE DBName SET MULTI_USER

 

From this command :

but its not coming online and multiuser then i run this command : UPDATE SYSDATABASES SET STATUS=24 WHERE NAME='DBNAME' and it comes online but whenever sql sever services get restarted it again goes into suspect mode.

 

Please help somebody?

 

save and load RDL/RDLC with Data(offline mode with reportviewer), load RDL/RDLC with saved data in r

  
Hello every one
We are new to SSRS.
we have a client server application and have reports in crystal report, for each request to report from client we run report in server and then send saved rpt(crystal report file that data is embedded in file ) to client and after that load it to client crystal report viewer. clients can saved report file with data and load it in another time(truly we don't use crystal as report server and our application manage reports ).
we plan to use SSRS in our application instead of crystal report(for problems that there are in crystal version and deployment of crystal report packages ). in our scenario we need use RDL without server truly just application use server but client just receive report file and load it to RDL/RDLC ReportViewer and reportviewr run in local mode without communicate with server like crystal previous solution we need clients can save report with data and reload it in another time. we can't find any solution for it.

Are there any solution to save RDL/RDLC file with Data and load it again in Reportviewer?

Can use *.rdl.data for it?


Why there is not any easy way to embed data in Rdl  or Rdlc file and reload them with data?

Is it a weakness of SSRS and SSRS has any plan t

Database is looking as (Suspect/readonly/offline/emergency/)

  
Could not open FCB for invalid file ID 0 in database 'mssc_admin' and database is looking as (Suspect/readonly/offline/emergency/) Actually log file is not visibiling and I was trying to restore it.   PLease PLease help"SQLSERVER DBA" "INDIA"

Taking some SharePoint tables offline only, not all

  
I use MS Access 2007 and SharePoint 2007. I have designed a database that is shared in our group. I am using SharePoint to share the tables. Some tables I would like to keep always online. For performance reasons I would like to take other tables offline and synchronize them from time to time only. Is it possible to take only some SharePoint tables offline, not all? An alternative solution to the problem would be if I can automatically synchronize foreign keys after private keys change when SharePoint comes back online. I haven't found a way to do so. Is there any way to do so? Thanks a lot in advance.

Verification of signature "revocation server was offline"

  
Hi, I have to verify a (detached) signature from a third party. I am using System.Security.Cryptography.Pkcs.SignedCMS (VS2008) to validate the Signature. The verification of the data works fine. But when I try to verify the used certificates I always get that the intermediate certificate is not valid. The ChainStatus returns RevocationStatusUnknown (UnknownError) and OfflineRevocation (UnknownError) even if I set the RevocationMode to NoCheck on the chain. Dim byteData() As Byte = IO.File.ReadAllBytes(DataFile.FullName) Dim byteSignature() As Byte = IO.File.ReadAllBytes(SignatureFile.FullName) Dim ciData As New Pkcs.ContentInfo(New Oid("data"), byteData) Dim Verifier As New Pkcs.SignedCms(ciData, True) Try Verifier.Decode(byteSignature) Verifier.CheckSignature(True) Catch crex As CryptographicException ' Signature is not valid Catch ex As Exception ' Verification failed End Try For Each SignatureCertificate As X509Certificates.X509Certificate2 In Verifier.Certificates Dim certChain As New X509Certificates.X509Chain(True) certChain.Build(SignatureCertificate) ' Build the certificate chain from the signers certificate certChain.ChainPolicy.RevocationMode = X509Certificates.X509RevocationMode.NoCheck For Each certElement As X509Certificates.X509ChainElement In certChain.ChainElements If Not certElement.Certificate.Verify() Then ' Cert

Error in attaching database file and creating a new connection

  
I am having problem when i was trying to attach .mdf file while create a new connection of SQL server, create a new connection of SQL database file and open the database in Server Explorer. I am using VS 2010 Ultimate and SQL Express 2008 R2.Can anyone please tell me what is the problem I am facing?Here are the error message.1. Attach .mdf in SQL database file and open the database in Server Explorer2. Create a new SQL server and attach .mdf

Catching offline website?

  
Hi! I have an intranet where we display the 5 latest news article headlines from the BBC. The problem I am having just now is if the BBC website or their XML feed is formatted incorrectly it takes our intranet offline, throwing up a ASP.net error screen. What I would prefer it to do is to post a message saying BBC Feed currently offline. protected void Page_Load(object sender, EventArgs e) { //SPECIAL Message AREA SqlConnection connMsg; string cs = ConfigurationManager.ConnectionStrings["SpecialConnectionString"].ConnectionString; connMsg = new SqlConnection(cs); connMsg.Open(); SqlCommand msgCOM; msgCOM = new SqlCommand("SELECT * FROM [msg_table] ORDER BY [msg_id] Desc", connMsg); SqlDataReader DRMsg = msgCOM.ExecuteReader(); if (DRMsg.HasRows) { while (DRMsg.Read()) { DateTime varDate = Convert.ToDateTime(DRMsg["msg_date"]); string varContMessage = Convert.ToString(DRMsg["msg_content"]); Literal LiteralMessage = new Literal(); LiteralMessage.Text = "<div class=\"specialMessageDate\">"+ varDate.ToString("g") + "</div><strong>" + varContMessage + "</strong><br /><br />&

Installing SQL Server 2005 Express Offline

  
This may seem simple but for some reason I am having a problem.I am trying to install SQL Server Express 2005 on Windows XP Service Pack 2 which has not been online for a while.Can anyone help me with the steps to installing this on the computer. Everytime I've tried it has told me that it doesn't meet the minimum requirements. I am not sure if its because I am sick and dazed out why i can't seem to find the answer but I would really appreciate the assistance.Thank You,Carlitta

Take site offline for all users except administrator

  
Is it possible to take site offline for all users, but give admins ability to use and edit it? Maybe something like app_offline.htm, but not for all users. Thanks a lot.

tracking sharepoint file offline usage

  
Hi: I am searching for a commercial application which can track SharePoint document usage offline. The sceanrio will be: 1. Download sharepoint ( 2007 or 2010) server hosted document to a laptop.   2. Disconnect the laptop from internet. 3. Access the doucment with difference users. 4. Track who and how many times those documents are accessed. 5. When the laptop is reconnected with intranet, the tracking information from step 4 can be synchronized with Sharepoint server  reporting tools My question is: "is there an out of box application supporting this feature and what are their names?" Thanks a lot.

tracking sharepoing offline usage.

  
Hi: I am searching for a commercial application which can track SharePoint document usage offline. The sceanrio will be: 1. Download sharepoint (2010) server hosted document to a laptop.   2. Disconnect the laptop from internet. 3. Access the doucment with difference users. 4. Track who and how many times those documents are accessed. 5. When the laptop is reconnected with intranet, the tracking information from step 4 can be synchronized with Sharepoint server  reporting tools My question is: "is there an out of box application supporting this feature and what are their names?" Thanks a lot.

Did a dumb thing with Sql Server Loging IS / Offline / Single Integrated User / sa disabled [dumb?]

  
Have been using a single database (targetDb) outside of the master with Integrated Security Fairly new installation.... sa login is not enabled (?) Default database for my integrated ID is this "targetDb" And then took targetDb "offline", instead of Detaching during a machine swap process. No I can get in to the server/database, because the IntegratedWindowsLogin cannot login, because the tragetDb (default database) is offline.  sa cannot login, either - because is is not active. What do we do?  Travis McGee

Take Offline The Application Server

  

Hi All,

I have a farm MOSS 2007 with 2 Frontend, 1 Application, 1 Cluster Sql2005.

If i Take offline the Application Server, The SSP services Stop Working? If Yes, can I add a second Application Server Instead of the First one?

 

Thanks


Andrea

Display help in an offline environment

  

I have installed my SharePoint farm environment in an configuration where it is not connected to the internet. When I try to open help by clicking the help button on my site collection I get a classic page cannot be found error. I have tried to install the help collections again with the hcinstall command, and I have checked that the necessary flags are set under site administration -> Help Settings but no help, it still tries to go online. The help function in Central Admin works fine so it's only on regular sites I have the issue.

So my question is:

Is the help collections that comes with SharePoint only based on online connection? Or is there a way to make this available offline?


Cannot create offline cube in Excel via http

  

Hi,

we have an Analysis Server and it is accessible via http and that is all working fine, but if you try to create an offline cube on a PC which is not located in our company network it ends up every time in a failure like "OLE DB Error:...The specified host is unknown. .; either can not connect to the server..."

Any ideas? It seems so to me that for creating the offline cube, the connection string is broken or something like that...

KR

Peter


Can multiple users connect simulateously to an offline cube created by SSAS 2008?

  

We have created an offline cube on a network drive from SSAS 2008 and users are able to successfully access this serially using the Excel 2003 cube add-in or Excel 2007, in concert with version 10 driver, but when a user is already connected, the second attempt to connect will get the message :

Connection to <filename> server, <dbname> database, <cubename> cube failed.  OLAP Server error: The following system error occurred:  The process cannot access the file because it is being used by another process. ., File system error: An error occurred while opening the '<filename>' local cube file.

This is regardless of whether users connect specifying read-only and we have found it impossible to connect to a cube if the file has the read-only attribute set.

Is there any way to solve this without users taking copies onto their workstations?

 


MickO2
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend