is it possible to connect to SQL Express without network?

SQL Server Express

Index ‹ SQL Server

- Previous
  - 1
    - static variables in a SQLCLR stored proc seem to get reused from execution to execution of the sp after moving off VS debugger and into management studio to exercise our SQLCLR sp, we notice that the 2nd execution gets an error suggesting that our static SqlCommand object is getting reused from the 1st execution (of the sp under mgt studio). If this is expected behavior, we have no problem limiting our statics to only completely reusable objects but would first like to know if this is expected Is the fact that debugger doesnt show this behavior also expected Tag: is it possible to connect to SQL Express without network?
  - 2
    - Add list as parent for rectangle in rdl Hi! I have a report designed with all the tables in the rectangles on the rdl. Right now, I need add "list" control on the top of those rectagles(including all the tables) so all the rectangles have list as parent I don't want to start over to just for adding the list. I was trying to edit report xml file to add the "list" on the top of rectangles but the compiler complains. The rectangle property has "parent" field ,which is "body" right now. How can I make it's parent as "list" This field is grey out so I can not change it in the property window. Any idea Thanks. Tag: is it possible to connect to SQL Express without network?
  - 3
    - Printing in Reporting Services hangs Am having exactly the same problem as described - Report Services hangs on Print or Preview.. It used to work a few months ago - now exactly as described... *** We can print to files without issue - only when we try to print to a real printer does it hang forever. It doesn't matter how big the report is, 100 pages or 1/4 of a page, same problem. We do the following: 1) Run the report 2) Click the print button 3) Select a printer and press ok 4) "Printing Now..." dialog box appears 5) "Print Error" dialog appears and never goes away - and nothing is printed out. Have to close IE and crash the report session to get out of it. This is the result on every client computer we have ever used in trying to access the report server. It also hangs in running a Print Preview for all reports. *** Yep Exactly - Help Also! WinXp Sp2+winupdate all current, vs2005sp1, sql2005sp2- all up to date! - Box is stable, smooth no problems except this RsClientPrint problem...if i enable script debugging and let it sit long enough to get the error dialog "An error occured during printing." I can attach the debugger though! Here it is... *** <HTML> <BODY onload="Print()"> <OBJECT ID="RSClientPrint" CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" CODEBASE="/Reports/Reserved.ReportViewerWebControl.axd ReportSession=1fkaywuhrsf0nx3xffaqfs55&ControlID=66deb65aa11844df954e9e62fcc1feec&Culture=1033&UICulture=9&ReportStack=1&OpType=PrintCab#Version=2005,090,3042,00" VIEWASTEXT></OBJECT> <script language="javascript"> function Print() { if (typeof RSClientPrint.Print == "undefined") { alert("Unable to load client print control."); return; } RSClientPrint.MarginLeft = 25.4; RSClientPrint.MarginTop = 25.4; RSClientPrint.MarginRight = 25.4; RSClientPrint.MarginBottom = 25.4; RSClientPrint.PageHeight = 279.4; RSClientPrint.PageWidth = 215.9; RSClientPrint.Culture = 1033; RSClientPrint.UICulture = 9; RSClientPrint.UseEmfPlus = true; *** The Debugger has the line below marked( in Yellow - with an Exception has Occured... *** RSClientPrint.Print("/Reports/Reserved.ReportViewerWebControl.axd", ReportSession=1fkaywuhrsf0nx3xffaqfs55&ControlID=66deb65aa11844df954e9e62fcc1feec&Culture=1033&UICulture=9&ReportStack=1&OpType=PrintRequest", "StkGainers") *** The line above is the exception point... } </script> </BODY> </HTML> *** More Details: when problem started i was on Sql2005 sp1 - i noticed sql2005sp2 was released so i applied it! Everythin is "The Most Current", I followed How to enable Reporting Services Client printing, and how to configure the browser for RsClientPrint" RsClientPrint is downloaded, installed and current - version 2005.90.3042 ( way current! 3/4/07) *** And it used to work on this box!!! - lets see, what have i done since i know client printing worked - I allowed ie7 and .NetFramework 3.0 to be installed via WindowsUpdate - and an update to framework 2.0 - Hmmmm I've uninstalled ie7 and back to ie6 most current... I'll try more debuggin, try to step into RsClientPrint.Print some more... But surely, someone knows the FIX allready... So Please Help! R Lewis - MCSD - rplewis419@bellsouth.net PS: *** I can let some one remote in to the problem if they like! But they gotta promise to fix it( I hope anyway) Hmm... Guess i'm not current (problems, problems...) Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available SQL Server 2005 Reporting Services, 32-bit version File name File version File size Date Time Platform Microsoft.reportingservices.diagnostics.dll 9.0.3152.0 800,112 03-Mar-2007 07:53 x86 Msmdlocal.dll 9.0.3152.0 15,930,224 03-Mar-2007 07:53 x86 Msmgdsrv.dll 9.0.3152.0 6,041,456 03-Mar-2007 07:53 x86 Reportingservicesservice.exe 9.0.3152.0 17,264 03-Mar-2007 07:53 x86 Oooo .3152... ( might as well try it!!!). Tag: is it possible to connect to SQL Express without network?
  - 4
    - MICR Font Issue When Exporting to PDF anyone have a answer for this Tag: is it possible to connect to SQL Express without network?
  - 5
    - Stored Procedure adding new row What is ReportID and where is it defined You need to reference SCOPE_IDENTITY() to the id number of the row you just inserted. Code Snippet SET @tempNumber = 'REPORT-' + convert ( varchar ( 200 ), SCOPE_IDENTITY() ) Tag: is it possible to connect to SQL Express without network?
  - 6
    - Member Property length limitation I have a member property in a shared dimension MSAS 2000. The length of column from which this member property fetches value is nvarchar(2000). But the OLAP cube is reading only 255 characters ONLY. Is this a common limitation If yes, what is the alternative to increase its length to grater than 255 Any help will be greatly appreciated. Thanks. Tag: is it possible to connect to SQL Express without network?
  - 7
    - SQL Server 2005 Evaluation Install Error Hi Jackwc, you can open up a cmd window and run sqleval.exe /x which should pop a dialog asking for where to extract the package, pick one that you're sure that 1) your running account has write access to and 2) there is enough space at the location. Tag: is it possible to connect to SQL Express without network?
  - 8
    - Custom Control Flow Item Issue Yep, see the post above. Sorry, I missed the part about you executing the package via SSMS. *You* don't have SSIS installed on your local machine. If you were to create an Agent job on the server that pointed to the package, it would likely work fine. Tag: is it possible to connect to SQL Express without network?
  - 9
    - Move distribution data/log files to another drive I haven't found the definitive answer on how or if this can be done without removing replication. I'm thinking ALTER DATABASE modify_file is the way to go. Anybody know if this will work or a better way to go about it Thanks Tag: is it possible to connect to SQL Express without network?
  - 10
    - Data Source and Connection Manager But for me there is a big advantage : if you have many packages sharing the same connections and you have to change the connection, then you just have to change it in one place. If you use only connection manager, then you have to check all your packages. Tag: is it possible to connect to SQL Express without network?
  - 11
    - Query Execution failed for dataset error / the syntax for " " is incorrect Hi, Am totally new to MDX Queries. I got this error while previewing a report that we had made. It goes like this -- Query execution failed for dataset 'some_dataset'. Parser: the syntax for 'some_character' is incorrect. What was figured out was this error shows up only for those values in a particular dropdown list which are multiword. Eg : My Company Technology and not for those values which a re single word. Eg : Company what could be the possible problem and the solution to that. Tag: is it possible to connect to SQL Express without network?
  - 12
    - Month's end Hi, I am working on a cube that contains month standings and month totals. This works fine if I select one month. It goes wrong when I do a year to date selection because it sums up the month standings. How can I make a cube that does sum up the month total but only returns the last month standings. With regards, Constantijn Enders Tag: is it possible to connect to SQL Express without network?
  - 13
    - Backup File Name Dear all, On scheduling the online backup for SQL server 2005 with SQL server management studio, how the backup filename can be automatically change for everyday. I mean the backup filename be automatically generated every day. Thanks Imran Hasware Tag: is it possible to connect to SQL Express without network?
  - 14
    - CONTAINS and WHERE Clause Combination taking too long Hi, I have a table with 3 columns and 20 million records. first 2 columns have VARCHAR(4) data type and third column is VARCHAR(5000). I put 3rd column under FULLTEXT and implement a normal INDEX on 1st column. Now when i try to search SELECT TOP 20 col1, col3 FROM tbl WHERE col1 = '1234' AND CONTAINS(col3,'"market*"') I am facing following problems 1- It hang for like 1 minute and give 2 records, whereas if i remove col1='1234' from where clause it take less than 1 second. 2- Some time it show criteria is too complex, although i am only requesting a single word in col3. I am noob in FULL-TEXT but i have done all research in books, microsoft forum and Google and not getting any information. Please assist. Tag: is it possible to connect to SQL Express without network?
  - 15
    - stored procedures, compile or not >>>Stored procedures are the best way to go.<< >>Only if you are going to reuse the procedure... But even if you are not going to regularly reuse the stored procedure (perhaps execute it once a day for instance) then it is often easier to maintain, test and deploy stored procedures than it is to maintain, test and deploy the code routines that generate adhoc SQL. The WITH RECOMPILE option can also be useful if your stored procedure's input parameters vary wildly between executions where the currently-cached plan (from a previous execution) is not necessarily the most optimal plan for the current set of parameters. Chris Tag: is it possible to connect to SQL Express without network?
  - 16
    - Add connection error: 40 Hi i just reinstalled windows, and installed visual studio .net 2005 and the Sql server. But when im trying to add connection, select my computer at Server name, type a databasename then pressing OK i get this message: An error has occured while estabilishing a connection to the server. When connection to SQL server 2005, this faliure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Names pipes provider, error: 40 - Could not open a connection to SQL Server) Does anyone know what todo herman Tag: is it possible to connect to SQL Express without network?
- Next
  - 1
    - Cannot completely install/remove SQL Server Express I cannot use, remove, or reinstall Microsoft SQL Server 2005. Although Microsoft SQL Server 2005 and Microsoft SQL Server Setup Support Files appear in ControlPanel-ARP, when I attempt to remove Microsoft SQL Server 2005, the workstation component remains. If I try to download and reinstall Microsoft SQL Server Express from the Microsoft website, the download does not install completely as described below. My current situation is much better than the previous incompatibility or configuration problems I had been experiencing between Microsoft Office Small Buisness Accounting 2006, Microsoft Office Outlook 2003, Outlook Business Contact Manager, Microsoft SQL Server 2005 (express edition installed in conjunction with Visual Basic 2005 express), and Microsoft SQL Server Desktop Engine (installed in conjunction with Small Business Accounting 2006). The problems and error messages previously included: 1) A consistent bootup error (Net service configuration error...The specified service does not exist as an installed service); 2) The inability of Visual Basic to connect to an instance of SQL server (An error has occurred while establishing a connection to the server...); 3) a SQL server configuration manager error: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL server configuration manager. Invalid namespace [0x8004100e]; and 4) SQL server management studio express error: Cannot connect to <computername>\SQLEXPRESS... 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) (Microsoft SQL Server, Error: -1). These problems have been partially solved by: 1) completely removing Small Business Accounting 2006, Outlook Business Contact Manager Update, and MSDE (which appear to be codependent); and 2) removing and reinstalling Visual Basic 2005. However SQL Server still cannot be completely removed or reinstalled and therefore Visual Basic cannot connect to SQL datafiles. When I most recently tried to remove SQL server 2005 using ARP, the installer reported that only the workstation component remains (Version: 9.00.1399.06 Edition: Express Edition Patch level: 9.00.1399.06), but is not removed by the ARP process. When I most recently tried to install SQL server 2005, the Setup Support Files install correctly, the System Configuration Check passes, but setup fails for MSXML6, SQL Server Database Services, and WorkStation components Books Online (detail log SQLSetup0068 file). According to Add/Remove programs, the following applications are installed: Microsoft Visual Basic 2005 Express Edition ENU Microsoft SQL Server Native Client Microsoft SQL Server Setup Support Files (English) Microsoft SQL Server VSS Writer Microsoft SQL Server 2005 Various MSXML versions Any help in un/reinstalling or configuring Microsoft SQL Server 2005 for use with Microsoft Visual Basic 2005 Express Edition would be dearly appreciated. Thanks. Tag: is it possible to connect to SQL Express without network?
  - 2
    - Transaction log backup error The server SQL Server 2005 is comprised of two servers. Both machines utilize RAID 1, or disk mirroring, if this is what you're asking me about. Besides, I do not think that databases are configured for mirroring. Tag: is it possible to connect to SQL Express without network?
  - 3
    - Email as csv using Database Mail Hi everyone, I'm having problems sending my query results as a csv file. Ideally I would be able to send my results from a sql job every night as a csv but I'm having problems doing it. My code is shown below Code Block EXEC msdb.dbo.sp_send_dbmail @profile_name = 'admin' ,@recipients = m@m.com ,@subject = 'Notification Created Today' ,@attach_query_result_as_file = 1 ,@body_format = 'text' ,@query =' select a1 . c# , cli , fe , type , dateReq , p , ( select convert ( varchar ( 50 ), convert ( money , amount ), 1 )), ( select convert ( varchar ( 50 ), convert ( money , vat ), 1 )),( select convert ( varchar ( 50 ), convert ( money , total ), 1 )), cReq from Disb_1 a1 inner join Details on a1 . c# = Details . c# where datediff ( day , getdate (), dateReq )= 0 and dateReq <= getdate ()' I've tried many different things and been through the parameters of sp_send_dbmail but I just cant find anything. Also, how can I use column names for those money conversions At the moment it just says 'no column name' Thanks, Steve Tag: is it possible to connect to SQL Express without network?
  - 4
    - convert timestamp to datetime arnie and konstantin are correct, we'll just have to ask LG how he implemented the timestamp field or variable that he had to come up with a requirement of converting timestamp to a datetime Tag: is it possible to connect to SQL Express without network?
  - 5
    - Unable to make changes to disconnected recordset Its been almost 10 years since I have had to do work with good-old RecordSet objects... I am filling a RecordSet with data returned from a SQL server via a stored procedure. I then set the ActiveConnection property to Nothing in order to disconnect it so I can make changes to it. But when I try to set the value on a given row I get back a "Multiple-step operation generated errors. Check each status value" error message. My understanding is that this is indicative of trying to use the wrong datatype. I have verified that the type is correct (I am dealing with integers) so I am at a loss for what the problem could be. Here is my code: Set rsPackages = CreateObject("ADODB.RecordSet") rsPackages.CursorLocation = adUseClient rsPackages.LockType = adLockBatchOptimistic rsPackages.Open "EXECUTE stp_FetchPackageData", myConn rsPackages.ActiveConnection = Nothing Response.Write("Value: " & rsPackages("TotalCount")) ' returns 0 Response.Write("Data Type : " & rsPackages.Fields("TotalCount").Type) ' returns 3 = adInteger rsPackages("TotalCount") = 1 ' throws multi-step error Oddly enough, when I look at the Attribute property of the field I get back a value of 112. When you break it down I think that value indicates the row value is read-only (Could that be my problem Just a really bad/unhelpful error message ) But if I try to change it I get back a message saying cannot be done since RecordSet is already open. Thanks, Jason Tag: is it possible to connect to SQL Express without network?
  - 6
    - What is wrong with my codes to connect VB.net to sql server 2005 Express database? Can you more specific, as you know I am new VB & SQL and now I am confusing: I use: Dim MyConnection string = "Server=localhost; DataBase= Trial1; Integrated Security =SSPI" (error) If I use: Dim MyConnection = "Server=localhost; DataBase= Trial1; Integrated Security =SSPI" then it is OK But I can not do the rest as you suggested, would you please provide some correct declarations, I will very appreciate it! Tag: is it possible to connect to SQL Express without network?
  - 7
    - I am new this SSIS, Please help me. Sridhar, Apart from msdn and latest downloadable samples from microsoft site, There are lots of online resources. 1) www.sqlis.com by Darren Green and Allan Mitchell 2) Download Free Samples at Wrox official site 2) Blogs by Jamie Thomson,Rafael Salas, Brian Knight, Donald Farmer, Kirk Haselden, Scott Barret, John welch, Ashwin Sharma, Phil Brammer, Michael Entin, Alberto Ferari Many Thanks Subhash Subramanyam Tag: is it possible to connect to SQL Express without network?
  - 8
    - No Parameter Pane when Reporting in 2005 against a 2000 AS Cube I have this strange issue. VS2005 SSRS2005 SSAS2000 cube based on data from SQL 2005 database When i connect to the SSAS cube and create a dataset in a SSRS 2005 report i do not get a parameter pane. Also, if i right click on a dimension & select "Add to filter" i get the following error message "Object reference not set to an instance of an object" It's not my installation of SQL 2005, as I can connect to an SSAS2005 cube and get the filter/parameter pane and do not get the error message. Parameters work fine. Have i come across a known issue when reporting on SQL 2005 versus a SQL 2000 AS Cube... or can someone shed some light on the issue for me.... If someone can tell me how to display screenshots I can add them to a post Thanks Will Tag: is it possible to connect to SQL Express without network?
  - 9
    - Rolling back transactions for multiple Stored PRocs I have a quick question. I need to execute some stored procedures in certain steps... all performing some inserts/updates What i need is, a mechanism, by which i can roll back to the previous state if i encounter an exception (either in the app or SP) so, if the my first two SP execute fine, perform their functionality like insert/update, and the third one fails... how can i roll back to the initial state in ASP.NET. would appreciate any info. or redirection to the the location where i can look up some info on that. AJ Tag: is it possible to connect to SQL Express without network?
  - 10
    - Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host. This looks really weird. I'll talk to a few other folks in the protocols team to see if I get more ideas to help you out. There is one bit that particularly gets my attention: the OLD query analyzer uses the old native data-access stack; the SQL Server 2005 setup, or the VS 2005 setup, do not touch any of those bits at all. So, if you're getting the same behavior from the old query analyzer, that may indicate that there was something else that changed and may be causing this glitch. Do you get failures in QA as often as you get with the other clients What error do you get in the QA case I'll reply again to this thread once I have more details or have someone do it. Regards, Pablo Castro Program Manager - ADO.NET Team Microsoft Corporation Tag: is it possible to connect to SQL Express without network?
  - 11
    - Problem With Common Table Expression (CTE) I constructed the following but I get an error results trying to run it. What am I doing wrong Error: Msg 530, Level 16, State 1, Line 1 The statement terminated. The maximum recursion 2 has been exhausted before statement completion. WITH AllPNBom ( [Parent Part Number] , [Component Part Number] , ItemId , ParentId , Part_Class , HLevel ) AS ( -- Anchor member definition SELECT [Parent Part Number] , [Component Part Number] , ItemId , ParentId , Part_Class , 0 AS HLevel FROM AllBoms WHERE [Parent Part Number] = '305-0345-001' UNION ALL -- Recursive member definition SELECT e . [Parent Part Number] , e . [Component Part Number] , e . ItemId , e . ParentId , e . Part_Class , apb . HLevel + 1 as HLevel FROM AllBoms e INNER JOIN AllPNBom apb ON e . ParentId = apb . ItemID ) -- Statement that executes the CTE SELECT * from AllPNBom order by HLevel , [Component Part Number] Option ( maxrecursion 2 ) Tag: is it possible to connect to SQL Express without network?
  - 12
    - Upgrading memory in a SQL 2005 2 node active/passive cluster Could someone give me an ideal of what it takes to upgrade the memory in my cluster. Is it as easy has upgrading the passive node, switching the nodes, then upgrading the other server. And do I need to re-configure the windows cluster. And will both server need to be down at the same time at any point. Or is their more to the process Thanks for any assistance. btw, I currently have 16mb of RAM in each node. Tag: is it possible to connect to SQL Express without network?
  - 13
    - Differences between 2000 and 2005 Arnie Rowland wrote: Yes, there is a lot of new functionality that can be employed in User Defined Functions. New T-SQL keywords, xml datatypes, xquery, clr functions, etc. The list of new capabilities is very long. Can you be more specific about your needs Sorry... I meant besides new functionnalities in SQL Server 2005 (which cannot be used in 2000). We found the problem... We were trying to implement a function to bypass the real datetime. So instead of using getdate(), we would use fn_getdate(). fn_getdate() returns either a date from a table or getdate() if no value is found. In SQL 2000 you cannot use getdate() in a function. That was the source of the error. Thanks Tag: is it possible to connect to SQL Express without network?
  - 14
    - passing datetime variables into a bcp statement Team work! Tag: is it possible to connect to SQL Express without network?
  - 15
    - Hiding/Showing columns based on the columns present in the dataset I have query which retrieves multiple column vary from 5 to 15 based on input parameter passed.I am using table to map all this column.If column is not retrieved in the dataset(I am not talking abt Null data but column is completely missing) then I want to hide it in my report. Can I do that Any reply showing me the right way is appricited. -Thanks, Digs Tag: is it possible to connect to SQL Express without network?
  - 16
    - Security exception when calling custom code from a report. I have also run into this problem, and have tried everything i can find to resolve this situation however i am still coming up dry. Background info: I have designed and tested a report using a custom assembly in Visual Studio 2005. The report runs perfectly in Visual Studio. I uploaded the report to the report server, in the following directory: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin At this point i was able to access the report and run it fine from within the web report viewer of Microsoft CRM (the application that the report was designed for use with) however certain elements of the report would not render. I noticed that the elements in question are ones that rely on my custom assembly ( which accesses data from an SQL database running on the same SQL server as reporting services ). I then tracked that issue to the fact that my custom assembly was not signed and strongly named, and therefore didnt have the permissions required to access the SQL server data. So i generated a key and signed the assembly. I tried placing the assembly in the GAC after signing it, however when running the report it claimed that it could not find the assembly file, so i moved it back into the bin directory of the reporting server. Now when running the report i get the error: "Failed to load expression host assembly. Details: That assembly does not allow partially trusted callers. (rsErrorLoadingExprHostAssembly)" At this point i have hit a dead end, i need to find a solution to this issue as this report needs to be run from our local intranet. Any help on this would be greatly appriciated, thanks in advance. Tag: is it possible to connect to SQL Express without network?

Ocherk

I have notebook, client server application and sql express sp2 on this notebook.

Also, I know domain user login/password,

but I don't know any local user name/password

and I don't know any sql server user name/password.

Domain user is not a local administrator on this notebook.

When notebook connected to the office LAN I am working good with my app-> my sql express as a domain/user.

I'd like to work at home too. I can logon to the system (XP SP2) using domain account when notebook has no network connection. (probably OS caches something)

Is it possible to work with sql express using domain login when no network connection

PS. old version of this software used MSDE 2000 and it was possible(!).

Thank you.

Re: is it possible to connect to SQL Express without network?

Arnie Rowland

Yes. SQL Server will still work the same as when you are connected to the office LAN.

Since you log on with your domain credentials (they are cached on the laptop), the same credentials are used to gain entry to SQL Server.

Re: is it possible to connect to SQL Express without network?

Ocherk

Arnie Rowland wrote:

Yes. SQL Server will still work the same as when you are connected to the office LAN.

Since you log on with your domain credentials (they are cached on the laptop), the same credentials are used to gain entry to SQL Server.

Ok, thank you.

I did experiment on 2 workstations.

On one machine ist working good, but on the second machine (no netowrk connection) when I tried to connect to the sql server I have a problem:

SSMS is ocnnecting ok

Application gives me message: cannot generate SSPI context.

What can it be ...

Thank you

Re: is it possible to connect to SQL Express without network?

Arnie Rowland

Check these souces:

Error -Cannot generate SSPI context
http://support.microsoft.com/Default.aspx id=811889
http://support.microsoft.com/kb/827422/en-us
http://support.microsoft.com/kb/843248/en-us
http://support.microsoft.com/kb/269541/en-us
http://support.microsoft.com/kb/267588/en-us
http://support.microsoft.com/kb/814401/en-us
http://support.microsoft.com/kb/818173/en-us