Click here to Skip to main content
15,891,136 members
Everything / Server

Server

server

Great Reads

by Kel_
Presents a real-time gauge implementation that can be used for building dashboards
by honey the codewitch
Add the ability to run a service in console mode and to control or install your service from the command line
by pepethepepe
Access realtime Linux Web server statistics right away from Windows Store App
by Tharaka MTR
This post will show you how to fix orphaned SQL users.

Latest Articles

by Federico Di Marco
A tool which creates one or more Powershell scripts which in turn recreate one or more binary files
by deangi
An ESP32 is used to track water usage and serve web pages with water use data
by Greg Utas
Are we about to go over a cliff?
by Greg Utas
The well-tempered server

All Articles

Sort by Title

Server 

27 Mar 2013 by Reddeppa G
this procedure should work in sql server 2005 only...NOT IN SQL SERVER 2008
21 Jun 2017 by JatinKhimani
I know that is this question has dozen of answers and posts, but nothing works for me. We have my MVC4 application and i deployed it to IIS7 to my server and one more machine where we don't have visual studio installed. We are doing import/export data from/to excel for doing bulk entry. we do...
20 Feb 2022 by him_mca
hi team, while executing below query getting the Quote: 'STRING_AGG' is not a recognized built-in function name. AS my server has SQL server version 2016 and my dev mechine having SQL server 2017 Quote: SELECT distinct...
20 Feb 2022 by Graeme_Grant
A quick google search sql server string_agg 2016 found this solution: STRING_AGG replacement in SQL Server 2016 [duplicate]
27 Sep 2010 by Mathuraiveeran.P
SQL Server 2005 Database Backup and Restore using C# and .NET 2008,without username and password.
27 Sep 2010 by DaveAuld
Shutdown the database services.Copy the data files from the SQL data store paths.
12 Jul 2013 by pokemonjohn
HiI have a windows service which i have been using on a windows server 2008 for some time with out any issues.I'm no trying to get this to work on a windows Server 2012 box.The windows service has an installer project and will install / uninstall fine on both servers, how ever on the...
14 Jan 2014 by ASP.NET Community
IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide
23 May 2010 by ibraaaa
I'm developing an Asynchronous Game Server using .Net Socket Asynchronous Model( BeginAccept/EndAccept...etc.)The problem I'm facing is described like that:When I have only one client connected the server response time is very fast but once a second client connects, the server response...
28 May 2010 by ibraaaa
-disabled Nagle Algorithm i.e. set Socket.NoDelay = true-in WaitForData method, moved call to BeginRecieve befor handling the previously received packet
10 Nov 2014 by getbacktosrinu
I am working on a problem plaguing an already established client system.So don't ask why this is set up this way :)The client doesn't want any major changes to the system as this is working on production.The system is set up this way:1. BizTalk receives a message (let us call this...
9 Dec 2015 by _Q12_
I use this code to be able to read a web page content.I don't know what is doing. All I know is that is working for every website I test it. I have a separate button for this code I provide here, just to initialize something - I presume is the server initialization. After the server...
23 Jan 2014 by dedo1991
Hi,I have a server with windows server 2008 r2 installed where i have my public IP XX.XX.XXX.XX and private IP address.I am trying to access the public IP address remotely on a computer through a web browser and this is the error message:403 - Forbidden: Access is denied.You do not...
24 Jan 2014 by vini2k1
Set the Application Pool Identities with your credential as explained here on server.
5 Jun 2013 by Mr. Mahesh Patel
Hi Experts,I have on asp.net application deployed on IIS 8 in Windows Server 2012 Standard Edition 64 Bit.In the dependency of my asp.net application, One DLL is present in its bin directory. This DLLis build on Any CPU Platform.Suppose The name of this DLL is X.dll build on Any...
5 Jun 2013 by Sergey Alexandrovich Kryukov
Just in case: did you take into account that there is one 32-bit x86 architecture, but two different, incompatible 64-bit architectures in Intel: x86-64, and IE64 (Itanium). If not, check it out:http://en.wikipedia.org/wiki/X86-64[^],http://en.wikipedia.org/wiki/Itanium[^].—SA
24 Feb 2014 by khoi tran
Hi every body,Please help me why i build a project to send mail, when i run at my computer that ok, So i run on another server have a error "The remote server returned an error: (401) Unauthorized.". I dont know that is my code error or server config my account.This is my code ...
24 Feb 2014 by khoi tran
yeah, i really done already. thank so much all, it error because my user on server should'nt have domain\
7 Dec 2015 by Ernesto Pabalan Jr.
Hello guys,I have a question. I have 5 computers, the 4 computers are installed with attendance system and the other computer is installed with SQL server 2014. When the users trigger the program simultaneously is there any disturbances on the system like hanging of the other computer or...
8 Dec 2015 by ZurdoDev
There is no way we can answer this because we cannot see the code nor your network. However, SQL server can handle many connections so unless someone wrote really poor code, it should be working fine. We would need a lot more info from you if you want anything more specific.
20 Jan 2014 by Asis Kumar Pati
Design the Database & answer the Following Question… (i). Find out the Grade of each student? (ii). Find out the Grade secured by maximum no. of students? (iii).Which is the most difficult question? [NOTE- There are 12 no students & 10 no of questions, each question having 4...
20 Jan 2014 by CPallini
Instead of posting your own homework here, you should try to do it yourself and ask here only specific questions.
20 Jan 2014 by thatraja
Well, Education Needed[^]And stop posting your homework questions. Spend some time to learn.
2 Sep 2010 by RobertH
Hi,I am looking for a simple SMTP proxy so that I can scan all email coming out of my email servers and add on some text/HTML code as needed for our company T&Cs etc.I would like it in c# or VB.Would this do the job?Robert.
2 Sep 2010 by HimanshuJoshi
This is not the forum for job posting. Post it on the Jobs[^] page.
19 Dec 2013 by rajin kp
table below shows a view of patient and their heightweight table . from this table i want to select height, weight, PatientId with max date in each moth for each patient ,Patient must have same birth date PatientIDHeightMeasuredDateBirthDate....Weight115012/12/2013...
19 Dec 2013 by Maciej Los
Please, read my comment to the question first.Try this:SELECT t1.PatientID, t2.Height, t1.MeasuredDate, t1.BirthDate, t2.WeightFROM ( SELECT PatientID, BirthDate, MONTH(MeasuredDate), MAX(MeasuredDate) AS MeasuredDate FROM PatiensTbl GROUP BY PatientID, BirthDate,...
28 Feb 2014 by noo_
Create trigger chooseBookAsBorrowed ON [dbo].[PersonBooks] after insert update [dbo].[Book] set IsBorrowed=((1)) where Book.BookID=PersonBooks.BookID
28 Feb 2014 by CHill60
You need to use the inserted table to work out what needs to be updated.Here's an article that may help Triggers -- SQL Server[^]
18 Dec 2013 by OriginalGriff
"please please....reply me fast."OK!We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial...
9 Sep 2013 by Ron Beyer
I don't think this is a valid concept in SQL, despite it being displayed in most query results like Excel SQL is completely different, there are no concepts of row offsets in SQL (even column offsets are not the same). Rows are not really related to each other, so you can't say that one row is a...
6 Feb 2014 by Sergey Alexandrovich Kryukov
Please don't re-post. You need to modify this page by using "Improve question" (one the page of your original question), not post it again, which is considered as abuse, by apparent reasons. The question cannot be answered because it is absolutely unclear. Please refrain from re-posting again,...
2 Apr 2010 by Ramana Nori
I've written a small MS Access 2007 program having links with the tables of SQL Server 2005 Express Edition. The problem is it worked out in development environment. But it's giving error during production environment.SQL State '08004'Sql Server Error: '4060'Server rejected the...
3 Apr 2010 by Luc Pattyn
This[^] might apply. If not, look here[^].:)
11 Oct 2010 by Roger Wright
I've done a bit of searching but haven't found much that's relevant, so I'll ask here...In my app I want the user to select a SQL Server database on the network using a control similar to the browser provided by the SQL Server Management Studio. Is there a built-in control for this, or do I...
11 Oct 2010 by Goutam Patra
Will this [^] help
13 Dec 2017 by Deekshaa Singh Chauhan
here i give 3 textboxes, quantity, amount and total price in 1 unit comboBox i want do when i enter in total amount textbox any amount like Rs. 51 then automatically calculate quantity in kg or grams, i dont understand how to i do to calculate quantity acording to amount. What I have tried: ...
12 Dec 2017 by ________________
double Quantity1 = 1.00; double Price1 = 60.0; double Price2 = 51.0; double Quantity2 = (Quantity1 / Price1) * Price2;
16 Jan 2024 by deangi
An ESP32 is used to track water usage and serve web pages with water use data
3 Mar 2010 by Nima.naqipoor
I wanna create a visual math exam . as you know math exam have equations and pictures.for example; in a win form I must have a picture that loads from database(I did it and loaded the image into picturebox), and I have a word document (the math question with equations ) that must be shown...
3 Mar 2010 by Christian Graus
nimanaqipoor wrote:1.I want to save this doc in database ;so what the data type must be to save it??depends on the database, but it could be blob, or image. That's if you want to save a file in it's native format, so the DB cannot do much with it. If you're doing that, it can sometimes be...
24 Nov 2014 by Member 4337101
My application consists of a c# client talking to a Windows service (the "server" code). This service talks to SQL Server and another service. Everything worked great after installation for some period of time (an hour or so) and then stopped. Upon investigation, we noticed that service's...
7 Jan 2013 by naresh1252
We have a database sql server 2008 r2.But i had a problem with the database mail option in management category.Can anyone tell me how to activate the database mail concept in sql server.I know how to create profiles and send test mails through the database, but the issue is i am unable to...
7 Jan 2013 by SalCon
You first need to enable database mail ... here is the codesp_CONFIGURE 'show advanced', 1GORECONFIGUREGOsp_CONFIGURE 'Database Mail XPs', 1GORECONFIGUREGOThe profiles and accounts will work fine after this.
8 Jan 2013 by SalCon
I hope this is not a SQL Server Express installation........ is it?
30 Mar 2011 by B Prasun Reddy
I am .Net Developer now I am in new project implementing iBatis Framework. In this project we are using Java Application as Front end and Back end as Sql Server.I want in what way I will connect to Java Front end to Sql Server Via iBatis Framework?If any one having answer for my question...
30 Mar 2011 by Henry Minute
There is a fairly good beginners tutorial for iBatis here.[^] and this[^] thread has details on getting connected to SQL Server.You should be aware though that there seems to be some splitting of the iBatis camp. Several of the members have started developing myBatis[^].I have no idea...
11 Jul 2012 by UpendraWatwe
Hello (Newkie[^]),I tried to implement your solution, but could not understand how to resolve the compile time error resulting from the x in values set to the flags.I have a windows server 2008 R2 DataCenter edition with SP1 (in process of being installed as my earlier attempt involved...
11 Jul 2012 by Sergey Alexandrovich Kryukov
Probably you are trying to address the author of some CodeProject article, but it could not work this way. Load the page with the original article and add a post at the "Comments and Discussions" section near the bottom, click "Comments and Discussions" to ask your question. The author will get...
26 Mar 2014 by Member 10700889
I am totally new to server administration, and I am doing some testing to see how ports work.I have two servers installed on my localhost, Tomcat7 and Virtuoso.I would like to offer a sparql service using myServer.com/sparql which is running on port 90 in virtuoso. However, I would like...
18 Jun 2014 by harry madaan
Hi All,can anyone help me to solve this issue please.You do not have permission to view this directory or page because of the access control list (ACL) configuration or encryption settings for this resource on the Web server.i've IIS7 with window server...
11 Sep 2016 by OriginalGriff
Restore from your backups.If you don't have backups, treat this as a learning exercise: you need a good solid backup regimen that is absolutely adhered to and regularly tested.
4 May 2011 by Member 3362773
Hi,I have a requirement to develop a web based mail monitoring tool for a supporting team using asp.net, c#. That tool should have to access Exchange Server (2007 or 2010) mail account by giving mail id and password and get those mails and store those in a SQL Server 2008 database. Can...
27 Apr 2011 by Kim Togo
Take a look at this http://www.independentsoft.com/[^] it is not for free. But has some really good API for .NET.
27 Apr 2011 by Kim Togo
Have you looked at Exchange Web Services Managed API 1.1 SDK[^]
5 May 2011 by Member 3362773
Hi,I could complete the difficult part of the requirement with the Exchange Web Service. The articles at the URLs given below were very helpful for it....
30 May 2011 by Member 3362773
Hi All,As I stated in my previous post,the required application completed with exchange Web Services. Thats working fine except one issue.When using SyncFolderItems method of the Exchange Web Services; the SyncState grows in size rapidly when there are more mails to be syncronised. (Ex:...
21 Nov 2011 by AditSheth
HelloI upload a photo using c#.It successfully uploaded on server.but it is not displayed on front. when i give a permission of folder where this images is uploaded and refresh page then it is displayed.but when i changed or uploaded other file it does not displayed again. I repeat same...
21 Nov 2011 by Ganesan Senthilvel
Itz not a problem with folder permission; itz with the file permission.I encountered the same problem. To find the root cause, right click on the specified file and go to properties. Under Security TAB, you need to have the access to EveryOne (at least read). Otherwise, you will have the...
27 May 2013 by akosisugar
Hi experts. ived just created an application in vb.net with a database. i want to deploy this application to my main pc/server. can i still have an access to this application to other pc/client by sending a shortcut to there desktop. something like that?.just need more information im still noob...
27 May 2013 by Maciej Los
Please, read these articles:Deploying Applications and Components[^]Chapter 8: Deploying Applications[^]Web Deployment Overview for Visual Studio and ASP.NET[^]
5 Sep 2012 by Behnam Mohammadi
hiWhen I want upload a file with fileUpload Control in asp.net I get this error on server .the server use plesk interface.Server Error in '/' Application.Access to the path '~\Upload\NewsImage' is denied.Description: An unhandled exception occurred during the execution of...
5 Sep 2012 by Andrei Straut
The solution comes from your own error message:To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired...
7 Nov 2021 by Member 15421434
Step : 1 Go to folder where you want to upload photo Step : 2 Right click on folder and select properties Step : 3 Than select security tab and select on Edit button Step : 4 Window will appear in which , press button "Add" Step : 5 And in...
28 Dec 2013 by NAGESH SRIVASTAVA
Server Error in '/' Application.Access to the path 'C:\Inetpub\vhosts\sssinfracity.com\httpdocs\Reports\Logistics_Report_by_Employee_on_12_29_2013.pdf' is denied.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for...
29 Dec 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)
Quote:[UnauthorizedAccessExcep...
16 Jan 2012 by amertarekt
I want to make my website on my home computer can be accessed all over the world from any computer at first i make my home computer to have fixed local ip and fixed public ip to be sure that they will not change any time second i put my website on the IIS and make it can be accessed in...
11 Oct 2013 by ASP.NET Community
1) Install SQL Server on Window Server 2003/2008 on Network (Select Network option when installing SQL Server)2) Configure Windows Server as a domain
15 Jan 2012 by soubins
Hi, I have accidenly deleted some important records from one table.Can you please provide any suggession to recover those records, as those are very important for us.The things I have is, backup: I have only two months old backup Trnasaction log: Not yet taken ...
15 Jan 2012 by OriginalGriff
Good luck: You are probably going to need it.Go here, look at this: http://www.red-gate.com/products/dba/sql-log-rescue/[^]If your last backup is two months old, then it may be your only hope. And don't waste time. Tell your boss now, before he finds out for himself, and tell him what...
12 Aug 2010 by Wildshane
Hi,I am looking at creating an activation service for a small app I am currently working on.Would just like to know if anyone knew of any good web tutorials or instructionals that described the current approaches to online activation of desktop applications.I am wanting to know a bit...
12 Aug 2010 by Yusuf
did you consult this guy[^]
8 Jan 2015 by sarath.mk
Hi friends I am executing the Powershell script through C# by using WSManConnectionInfo, I am making remote connection from my local machine to Lync Server and executing the below commands.using (Pipeline pipe = remoteRunspace.CreatePipeline()) {Command...
19 Jun 2011 by asok6783
i am having exchange server 2003 in windows server2003 using it for both mail and ftp server . now i have installed a new server now i want to shift the users and the mailbox from the old server to the new one please help me asok
19 Jun 2011 by Kim Togo
When you new server is Windows Server 2008 and Exchange 2010. You have to prepare the Active Directory[^] and then migrate all users to Exchange 2010[^].
28 Dec 2012 by StackQ
ALTER TABLE OrderTypeMaster ADD PckDtlReqd bit DEFAULT (0)i m using it but it takes default value nullplz help
28 Dec 2012 by OriginalGriff
Try:ALTER TABLE OrderTypeMaster ADD PckDtlReqd bit DEFAULT (0) NOT NULL
28 Dec 2012 by P.S Vijay
ALTER TABLE OrderTypeMasterADD PckDtlReqd BITGOALTER TABLE OrderTypeMaster ADD CONSTRAINT DF_OrderTypeMaster_PckDtlReqd DEFAULT 0 FOR PckDtlReqdRegards ,Vijay
28 Dec 2012 by kankeyan
ALTER TABLE OrderTypeMaster ADD PckDtlReqd bit DEFAULT (0) NOT NULL
28 Dec 2012 by StackQ
Alter table OrdertypeMaster add PckDtlReqd bit default(0) with values
28 Jan 2013 by Narendrakumar Arya
Hi All,My AutoCompleteExtender extends textbox.When I type some words in textbox result displays. But I want to display each values with checkbox (name,Email) to select multiple values. How can I do this? need a urgent help. See the below picture for reference.Thanks in advance
13 May 2014 by prakash.chakrala
Hi All,In a variable i have following valuedeclare @var varchar(20)='T,1'need to print the data as 'T','1'
13 May 2014 by scottgp
Doubling them up works, e.g. declare @var varchar(20)='''T'',''1'''print @var'T','1'
24 Oct 2017 by Member 13483961
Table Name is Employee EmpNo EmpName Salary 1 A 2000 2 B 1000 3 C 3000 4 D 2000 5 E 5000 I need to get one more column by adding salary of previous and current row as NewSal 2000 3000 4000 5000 7000 What I have tried: Select...
24 Oct 2017 by OriginalGriff
Look at the SQL LAG function: LAG (Transact-SQL) | Microsoft Docs[^] - the link includes examples.
14 Apr 2018 by Member 13738315
i have to insert the all rows values from datagridview to sql server database.But the first row could not be inserted. this is my coding... Dim conn As New SqlConnection Dim cmd As SqlCommand Dim sqlstring As String Dim paramdic As New Dictionary(Of String,...
14 Apr 2018 by RickZeeland
I suspect your StaffId is an autogenerated IDENTITY field that you do not have to pass in your query, try without this field. If you still have problems please create a script from your table and constraints and include it in your question. Btw. for testing it is often easier to use SQL Server...
14 Apr 2018 by RickZeeland
You need to use a loop to traverse all rows, like this: For Each row As DataGridViewRow In DataGridView1.Rows ... your code here Next Also you are not using your parameters for a parameterized query correctly, see example here: vb.net - How do I create a parameterized SQL query? Why Should I? -...
12 Jul 2015 by serigraphie
Hi Everyone,I've been dealing with this issue for four hours now and almost giving up. I just want to ask how create, delete, update and delete can be done with the use of datagrid and update SQL server. This is what I have: Private Sub LoadData() Try Dim...
12 Jul 2015 by Wendelius
Based on the error it looks like you don't have a primary key on the table. Please check again that you have a PRIMARY KEY constraint on the table, not a unique index or nothing similar. You can use for example SSMS ability to script the table to see what are the constraints on the table.As...
28 May 2013 by Rambo_Raja
is there any way to add a column to a table during runtime. That is suppose i have a table containing 4 columns...i have written a stored procedure for insert,del,upd operations also. now what i want is without using alter statement when i write select query automatically i get a additional...
29 May 2013 by Maciej Los
I'm not sure what you want to achieve...Maciej Los - wrote:Based on which condition do you want to divide employees on groups?R_sharma - ago wrote:any condition sir. i am not getting key to solve this question. could you please guide me to approach this and this type of...
29 May 2013 by Rambo_Raja
select empid, (case when empid between 1 and 2 then 'first' when empid=3 then 'second' else 'other' end ) as groupname from employee_testThis can be tried also. Both solutions worked for me.
4 May 2016 by Member 12078835
server window opens client windowclient connects server on portno=514connection done successfullybut when send message from the client to server give error messageAdditional information: Exception from HRESULT: 0x800A9C46Code Server Programusing System;using...
4 May 2016 by George Jonsson
The error message means Quote:"Wrong protocol or connection state for the requested transaction or request"So your connection might be in the wrong state for sending. Have you used the debugger to check the actual state?And why using AxMSWinsockLib? Any special reason, because I think...
16 Mar 2011 by coderChina
I am doing some Coding using VC++ 6.0 . In the Project the client connect to a table in the server with SQL Server2008. I use the ADO for the Database issues. The client have to show the table data instantly show real-time graph. So I use the ado enents but there few materials...
11 Oct 2013 by ASP.NET Community
First Create a XML as App_Data/Advertisements.xml    
14 Oct 2015 by Malikdanish
I have a desktop Application made in visual studio 2010 with SQL SERVER now SQL server 2005 Does not work for Windows 10 Now I want to change the SQL SERVER 2005 TO ADVANTAGE DATABASE SERVER
14 Oct 2015 by AnvilRanger
If you are referring to the product from Sybase/SAP, then you are in for a great deal of work. You would need to convert all objects from MSSQL to the new db platform. This step alone could be a huge undertaking. And then depending on your code you would have to change your entire DAL.The...