SQL Server Window Froze

Feb 25, 2002

Hi,
It happened to my sql server 5 times in three weeks. The window just froze and no response to any thing for my sql server. I need reboot server everytime to bring the server back. No any error log in SQl or window, Does any one can help on this one?
Helen

View 2 Replies


ADVERTISEMENT

How To Connect To Sql Server As Other's Window Login Rather Than User's Window Login Thorugh ASP.NET.

Dec 14, 2006

Dear members,

In MSDN, it says that it is recommended to use windows authentication to connect to SQL Server rather than use mixed authentication.

I create user deltasqluser on windows OS, and I specify in my webform ASP.NET script below :

protected System.Web.UI.WebControls.Label Label1;
private string _connString = @"data source=deltasql2000;initial catalog=northwind;integrated security=false;user id=deltasqluser";
/*
comment : I login to my windows as deltakoronx, and I want to every user (including me), connected to sql server through IIS, will be identified as deltasqluser not as user's login (impersonate)
*/
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection(_connString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select suser_sname()";

conn.Open();


string userName = cmd.ExecuteScalar() as string;
conn.Close();
conn.Close();
Label1.Text = userName;
}


at web.config, I add :
<identity impersonate="false" userName="deltasqluser" password="" />


at IIS webApplication1's properties, tab "Directory Security", at "Authentication and access control" section, I checked "enable anonymous access" with user : DELTAIUSR_DELTA and checked "Integrated Windows Authentication",


at query analyzer, I login as "sa" and execute script below :
exec sp_grantdbaccess 'deltasqluser','northwind'


when I run the ASP.NET script, error at conn.Open(); with error message :
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.


What should I do so that IIS login to SQL Server as user deltasqluser not as "NT AUTHORITYNETWORK SERVICE" ?

Regards,

Koronx

View 1 Replies View Related

Open Report In New Window: Window.open Method Gives Error

Jun 26, 2006



Hi,

I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.

I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.

How do I solve the problem?

Thanks

View 1 Replies View Related

Server Agent Window?

Feb 21, 2004

When I start the server agent - it opens up a black (command prompt type) window that seems to serve no purpose - that I know of yet.
What is this and can I stop it opening up all the time?

Thanks
JB

View 5 Replies View Related

SQL Server Login Window....

Jul 2, 2001

I have an desktop app that uses a system DSN to access SQL Server 7. I backed up a database from another machine and restored it on my machine. Now when my app starts, it prompts for login/pw for SQL Server. I have checked my ODBC connection, and the login and pw are correct. I have also used Enterprise Mgr to check it in SQL Server. Does anyone have any thoughts on why it is now popping up? Drop me a line at bcarlson@documentsolutions.com, and I can answer any questions. I was wondering if any info about the prev machine exists for the database (on the restore)?

Thanks,
Brian

View 1 Replies View Related

How To Install Sql Server On Window Xp

Feb 9, 2005

i m new to sql server , can any one help me how to install sql on window xp professional service pack 2.

View 6 Replies View Related

Sql Server 2000 With Window XP

Aug 8, 2006

Hi. I'm new to SQL server. I have here SQL server 2000 and i'm trying to install it on my computer that has the operating system window xp. I'm getting a message saying that the server can't be installed on this operating system. Is there something I am doing wrong? How could i install sql server 2000 on window xp?

View 11 Replies View Related

MS SQL Server Express - Is Console Window Available?

Mar 24, 2008

Hello everybody,
MySQL has a WebServer console, that lets to create tables via easy to handle SQL queries. Since I am used to SQL Server console, I would like to have such window in Micosoft SQL Server Express coming with Visual Studio 2008. Despite I searched for it, I did not find a database console window.


Does MS SQL Server Express offer a Server Console that lets the database to be accessed via SQL queries, please?

View 2 Replies View Related

How To Open SQL Server Jobs Window From VB. NET

Aug 17, 2005

Hello guys,I've one query regarding accessing SQL Server. I want to use SQL Server jobs scheduling functionality. Is it possible to open SQL Server's jobs window from VB.NET? (Server -> Management -> Jobs) Pls. help me to solve this query. Thanks in advance. Waiting for yr reply.

View 7 Replies View Related

Window NT Messaging Or Exchange Server ??

Dec 22, 2000

Hi

I have Outlook 2000 and SQL 7 .. do I need Window NT Messaging and Exchange Server to configure a profile for the mail to work ???

thanks in advance for the answer

View 2 Replies View Related

After Restoration Window 2000 Server

Mar 11, 2002

hi
i got a problem
sorry I'm not good at english

my windows 2000 os is failed so
the os was restored my me
after restoration i had a problem
the database is running but em and query analyzer is not running
and the server manager is not running also

should i reinstall the ms-sql server all over
or is there other way to correct this problem ?
I need your help thanks

View 1 Replies View Related

Any MS SQL Server Driver For JDBC For Window NT ?

Jul 20, 2005

Dear all,Any MS SQL server driver for JDBC for window NT ?Thanks for reply.Victoria

View 2 Replies View Related

SQL Server 2005 Summary Window

Nov 15, 2007

Probably simple but I cannot find the property setting that allows me to change the default date format of the column "Created" in the Summary window. Default it is 2007-11-15. As some tables are changed more than one time in a day, I would like to see also the time as was the standard in SQL SERVER 2000.
This is a minor problem but an irritating one!

Regards

Janne H.

View 5 Replies View Related

No Indication Of The SQL Server Edition In The About Window

Aug 20, 2006

I installed the SQL Server 2005 standard edition after uninstalling the Express edition.

When i look in the 'About' screen in the 'SQL Server Managment studio', i don't see indication that the SQL Server 2005 i currently work with is the Standard Edition. There are only categories and their numbers of versions.

How do i know that the Edition i work on ,now , is the Standard edition ?

View 3 Replies View Related

SQL 2005 - Window 2003 With IIS Server

Sep 11, 2006

Dear ALl,

We have SQL 2005 running on Window 2003.

Our Dev team created a web application. Which user we need to add in the database and what permission we need to assign him. So web application can do read, write and modify in the database tables.


Database name = ACCT
IIS server name = MASS     (running on different machine win 2003)

What role following accounts play in the connection of iis to database server login.

1: ASP.NET
2: MASSii$1  & massiis1

If
<indentitt impersonate = TRUE  or False> in the config file..


 

Thanks in advance.

 

 

 

View 1 Replies View Related

ASP.Net On Window Server 2000 - Database Access

Jun 27, 2006

Hi
I have problem in configuring my web project on Window server 2000. I have created the web application using Visual Studio 2005 tools. I have configured Window server 2000 with the .Net Framework Version 2.0. I can access the page which doesn't have database access.
The connection string in the web config file is giving me the problem that connection string can't be found. Does any one have any idea?
My database connection string looks like this.
<connectionStrings>
<add name="etzAusBldConnectionString" connectionString="Data Source=CASCADE;Initial Catalog=etzAusBldBaseData1;User ID=sa1;Password=****"
providerName="System.Data.SqlClient" />
</connectionStrings>
Moe

View 1 Replies View Related

How To Use Sql Server In Limited Window User Account

Oct 16, 2006

Ankush Jain writes "I m using Sql Server 2000 in Windoes XP (SP2) with Limited Window Account.
I m new to Sql Server.Please You can tell me how to create database.
When i expand the console root in Enterprise Manager it will show an error : "A connection could not be established to Local""

View 2 Replies View Related

Publish Window Application With Sql Server Express SP2

Feb 4, 2008

How do I get SQL Server 2005 Express Edition Service Pack 2 to show up in the prerequisites list when publishing the application?

Thanks

View 1 Replies View Related

SQL Server Management Studio - New Query Window

Jan 23, 2008

I'm trying to write a query with named parameters/variables in the Management Studio - New Query pane. Where should I post a question about how to create parameters/variables?

Thanks,
Gregory

View 5 Replies View Related

SQL Server 2012 :: Window Function On Different Date Ranges?

Feb 5, 2014

I have a question regarding windowing functions. I have a sales order table with the columns "orderid", "customerid", "order_date" and "amount". I use the following query to get the amount of every customer as a additional column:

Select customerid,
orderid,
order_date,
amount,
SUM(amount) OVER (PARTITION BY customerid)
FROM sales_orders

My question is if there is a good way to add another column, which includes the SUM(amount) of the customerid, where the order_date > 2012-01-15 , something like this:

Select customerid,
orderid,
order_date,
amount,
SUM(amount) OVER (PARTITION BY customerid),
SUM(amount) OVER (PARTITION BY customerid WHERE order_date > 2012-01-15)
FROM sales_orders

I know, this is not a valid method, so do you know a way to achieve this? Can I maybe use CROSS APPLY or something like this? I know that I could use a subquery to get this, but is there maybe a way / a better way via window functions?

View 9 Replies View Related

SQL Server Admin 2014 :: Window Failover Cluster

Jul 21, 2015

I have installed 2 node windows Fail-over clusters successfully. But QUARUM Configuration is not appearing in Failover cluster manager instead "Witness: Disk (Disk Cluster 4)". I have also configured quarum configuration from Quarum "Configure Cluster QUARUM Settings". I have attached the snapshots of windows cluster configuration. Is it the issue or not. I have not got any warning and error during cluster validation while installing Windows failover cluster. I am assuming it is okay and i can move ahead to installation of SQL Failover cluster setup.

Products used for installation in Virtual Machine:
Windows Server 2012 R2
SQL Server 2012 R2
Note: Service Pack is not installed.

View 2 Replies View Related

How To Launch SQL Server 2005 ReportViewer In A New Browser Window.

Dec 26, 2006

Hi all,

I am trying to launch ReportViewer in a new browser window, using the attribute: target='_blank'.

Can someone tell me how?

Here is the complete URL for the report .

http://SServer1/ReportServer?/Primary Members/Detail Report&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&UserName=sobo1

View 2 Replies View Related

Any Issues Installing SQL2000 SP4 On Window 2003 SP2 Server?

Nov 14, 2007

I was told that SQL2000 SP4 needs to install prior to installing SP2 for windows 2003 server. Is that true? What issues I will encounter if the installation is done the other way around?
Thanks for any insights

View 3 Replies View Related

Can I Access SQL Server 2005 Via A Window XP Pro Workgroup Network?

Aug 30, 2006

Hi,

I am new to SQL Server and I am trying to install SQL Server 2005 Express or Stnadard Edition on a computer runing XP pro on a XP's workgroup network using a router. Can I access the the database from another computer running XP pro on the same network? If I can, what setting do I need when installing SQL 2005 in order to do this?

Any help is appricated.

View 1 Replies View Related

SQL Server Admin 2014 :: BAK File Does Not Show In Restore Window

Jan 10, 2015

I have a windows 8 pc that I just got and installed sqlexpress 2014. My buddy haw windows 7 and installed sqlexpress on his pc. We create a db on his pc, did a backup, copied the backup to my pc. In ssms I right click on "database" > restore database. click device and the button to find my file. I navigate to the folder where the file shows in file explorer but the .bak file does not show in ssms to restore from. This is probably a windows thing but I have don't know what to look at.

View 4 Replies View Related

SQL Server 2012 :: Correlated Query To INNER JOIN Or Window Function

Mar 31, 2015

I'm having some performance issues with a TSQL query. It's a complex statement but the main issue is the correlated query.

How can I convert this

SELECT TOP 5
(SELECT SUM(lt2.col3)
FROM dbo.MyTable2 lt2
WHERElt2.col1 = lt.col1 AND lt2.col2 = lt.col2 AND lt2.id = lt.id ) AS Result
FROM dbo.MyTable1 t1
... to an inner join or a sql2012 window function?

By the way, I just added the TOP 5 myself while testing. It's not in the main query.

View 9 Replies View Related

SQL Server Admin 2014 :: Window Authentication Using Connection String

May 12, 2015

Is it possible to make window authentication using Connection String.

Like
Data Source="Remote Host"; User ID="user1"; Password="Password"
Integrated Security=SSPI'

user1 have rights on SQL server.

Is it possible user2 logged in on different machine can access SQL server.

user2 does not have rights on SQL Server.

View 3 Replies View Related

SQL Tools :: HotKey To Change Server Connection In Query Window

Oct 15, 2015

Hotkey combination to be able to change the server connection from Server A to Server B in a query window in SQL Management Studio? This is so you do not have to Right click, chose "Connection" and then chose "Change Connection".

View 2 Replies View Related

Cannot Find Server Or DNS Error When Using JAVASCRIPT Window.open With DNS Alias

Oct 15, 2007

Using SQL Server 2000 Reporting Services and want to open new IE window to link to a site.
We are using IE 6.0.

I am using the following Navigation "Jump to URL" in report:
javascript:void(window.open('http://www.microsoft.com/en/us/default.aspx'))

This works as expected if I am not using the DNS alias to reference Reporting Services. But if I use the DNS alias when referencing Reporting Services, then when I click the link in the report I get the "Cannot find server or DNS Error" in the IE window that opens. Everything else works correctly in the reports when I use the DNS alias.

Anyone have a clue why this is happening?

Thanks, DR

View 3 Replies View Related

SQL Server 2008 :: Tables Not Shown In Articles Window Of New Publication Wizard

May 26, 2015

We have restored a database on new server without keeping replication settings. Now while creating the publication no tables are shown in new publication wizard window. In fact we have hundred of tables in database and included in replication on source server from where backup was taken.

What may be the reason that tables are not appearing?

View 1 Replies View Related

SQL Server 2008 :: Partition Sliding Window Causing Loads Of Blocks

Oct 29, 2015

We have a massive database with an almost massive amount of traffic to and from it.

I've been requested to implement a sliding window partitioning with 2 partitions an active and passive 1,I managed to test this on a very small testbed last month.

I currently moved 97k table on to the partition function leaving me another 26 k to go

I'm using the following stored procedure to implement the sliding window

CREATE PROCEDURE [dbo].[ManageFactSlidingWindow](@pFunction nvarchar(max),@pSchema nvarchar(max),@FG nvarchar(max),@moveDays int)
/*****************************************************************************
PROCEDURE NAME: [ManageFactSlidingWindow]
AUTHOR: Arshad Ali
CREATED: 02/24/2013
DESCRIPTION: This stored procedure manages sliding window for the partitioned table

VERSION HISTORY:
DATE EMAIL Company DESCRIPTION

[Code] .....

When I try to move the partition even a single day I get loads of locks.

View 0 Replies View Related

SQL Server Agent Job Step Properties Window Loses Property Values Containing Semicolon (;)

May 16, 2007

Here's a weird one:



We are setting up a job for the SQL Server Agent via SSMS. The Job Step Type is SSIS.



In the Job Step Properties window, on the Set values tab, you can enter Values to override your package variables - normally all well and good.



However in this particular case, the variable Value contains semicolons ( - it is a Connection String for an ODBC driver. Eg: Driver={Client Access ODBC Driver (32-bit)};system=MYSERVER;...



The behaviour for this Value is weird:

If the Value is not surrounded with double quotes ("), the job fails with "The command line parameters are invalid."
If the Value is surrounded with double quotes ("), the job will run as intended. The catch is: that entry and any subsequent "Set Values" entries disappear next time the Job Step Properties window is opened.

This looks like a bug with the parsing of those strings by the Job Step Properties window?



Or am I missing something?



Mike

View 5 Replies View Related

Problem In Installing Sql Server 2005 Dev Edition On Window Vista Home Primium

Mar 22, 2008

i m trying to install sql server 2005 dev edition n window vista home primium.but onll book online part is installed.how can i install it.

View 1 Replies View Related







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