MSSQLWIKI

• Karthick P.K

  

• Categories

  • Always On
  • Backup/Restore
  • Configuration
  • Connectivity
  • Copy database wizard
  • Database mail
  • DBCC
  • Debugging
  • DTS/SSIS
  • Memory
  • Optimizer
  • Performance
  • Programming
  • Recovery
  • Replication
  • Security
  • Space management
  • SQL Cluster Setup
  • SQL General
  • SQL Query
  • SQL Saturday
  • SQL Server Cluster
  • SQL Server Engine
  • SQL Server I/O
  • SQL Server memory
  • SQL Server Setup
  • SQL Server Tools
  • SQLServer SOS
  • SSMS
  • Startup failures
  • Summary

• Archives

  • October 2020
  • January 2014
  • December 2013
  • November 2013
  • September 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • July 2011
  • June 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009

• Tags

  17883 17884 17887 17888 AllocateUserPhysicalPages AWE Allocator API's Blocking Connectivity CreateFile CreateMemoryResourceNotification Debugging Encrytion error 17883 non yielding Error: 15466 External dump process returned no errors External dump process returned no errors.DoMiniDump () encountered error GetClusterResourceState GetPerformanceInfo GetProcessMemoryInfo GetVolumeInformation Index usage Inside SQLOS Level 16 Linked server LockPagesinMemory LookupPrivilegeValue MapUserPhysicalPages max server memory memory dump memory leak non-yielding Non-yielding IOCP Listener Non-yielding Scheduler OpenCluster OpenClusterResource OpenProcess OSVERSIONINFOEX Overlapped I/O OVERLAPPED structure Performance Process 0:0:0 ( ) Worker appears to be non-yielding on Scheduler Profiler QueryMemoryResourceNotification Query tuning Replication Severity: 16 SOS SQL General SQLOS SQL Query sql scheduler SQL Server 2005 SQL Server 2008 SQLServer Cluster SQLServer CPU SQLServer dump SQL Server management studio sql server maximum server memory SQLServer mdmp sqlserver memory SQL Server memory SQLServer operating system sql server performance SQLServer scheduler SQLServer SOS SQLServer Tools SSMS Stack Dump State: 1. Trace Transactional replication UMS User mode sceduler VirtualAlloc What is SQLSOS?

• Facebook

  Facebook

• Twitter

  Tweets by MSSQLWIKI

• Do you have a question in SQL Server or stuck in SQL Server issue? Click here to join our facebook group and post your questions to SQL Server experts

• Email Subscription

  Enter your email address to subscribe to this blog and receive notifications of new posts by email.

  Email Address:

  Sign me up!

  Join 9,950 other subscribers

• SQLWiki

  • Programming
  • SQL Server Blogs
  • SQL Wiki
    • SQL Server Cluster
      • Known issues: SQL Server Cluster and standalone Setup
    • SQL Server Agent
      • SQL Agent MaxWorkerThreads and Agent subsystem
    • SQL Performance
      • Address Windowing Extensions
      • ASYNC_NETWORK_IO or NETWORK_IO
      • Lock pages in memory
      • Windows 2008 and Windows 2008 R2 Known issues related to working set /Memory
      • Basics of SQL Server Memory Architecture
      • SQL Server I/O Bottlenecks
      • Troubleshooting SQL Server Memory
  • Disclaimer

• Subscribe

  • Entries (RSS)
  • Comments (RSS)

• feedburner email subscription

  Subscribe to MSSQLWIKI by Email

• Visits

  

• SQL Server Blogs

  • Running 1 Million databases on Azure SQL
  • Top SQL Server blogs from MSSQLWIKI
  • SQL Server connectivity, Kerberos authentication and SQL Server SPN (Service Principal Name for SQL Server)
  • Transactional Replication Part -2
  • Transactional Replication Part -1
  • Tempdb latch contention
  • Troubleshooting Transactional replication Latency using Agent Statistics
  • The connection to the primary replica is not active. The command cannot be processed
  • False warning “A significant part of sql server process memory has been paged out”
  • What does MemoryUtilization in sys.dm_os_ring_buffers and Memory_utilization_percentage in sys.dm_os_process_memory represents?
  • SQL Server monitor
  • Max server memory – Do I need to configure?
  • SQL Server and VMware ballooning
  • Inside sys.dm_os_ring_buffers
  • SQL Server lock pages in memory
  • SQL Server -g
  • SQL Server Operating system (SOS) – Series 3
  • SQL Server Operating system (SOS) – Series 2
  • SQL Server Operating system (SOS) – Series 1
  • SQL Server fails to start with error "Failed allocate pages: FAIL_PAGE_ALLOCATION 1" During startup
  • Debugging memory Leaks using Debug diagnostic tool.
  • SQL Server memory leak
  • SQL Server NUMA load distribution
  • SQL Server Query optimization
  • SQL Server 2012 Memory
  • SQL Server Exception , EXCEPTION_ACCESS_VIOLATION and SQL Server Assertion
  • What is RESOURCE_SEMAPHORE_QUERY_COMPILE?
  • SQL Server Parameter sniffing
  • Optimizer Timeout or Optimizer memory abort
  • Troubleshooting SQL Server high CPU usage
  • SQL Server Latch & Debugging latch time out
  • SQL Server: Ghost records
  • I/O requests taking longer than 15 seconds to complete on file
  • Database Mail errors in SQL Server (Troubleshooting steps)
  • Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes
  • How to analyze Non-Yielding scheduler or Non-yielding IOCP Listener dumps ……
  • SQL Server generated Access Violation dumps while accessing oracle linked servers.
  • Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“
  • A significant part of SQL Server process memory has been paged out
  • What is Target Server Memory (KB)?
  • SQL Server performance degraded in 32-Bit SQL Server after adding additional RAM.
  • Transaction log for the database is growing and system SPID is holding open transaction
  • Copy database wizard or replication setup might fail due to broken dependency
  • SQL Server Agent is taking long time to start
  • (SQLServer) Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802.
  • Multi Threaded OVELAPPED and Nonbuffered I/O Example
  • Asynchronous I/O example
  • SQL-Server resource fails to come online IS Alive check fails
  • The backup of the file or filegroup "" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
  • How to move the LOB data from one file group to other?

• Author

  Karthick P.K

• Other SQL blogs

  • Sudarshan's SQL Server blog

• SQLSERVERSCRIBBLES.COM

  • Integration Services server cannot be configured because there are active operations. Wait until there are no active operations, and then try to configure the server again
  • SQL Server setup fails with “Failed to retrieve data for this request”
  • The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.
  • Sp_rename fails : Either the parameter @objname is ambiguous or the claimed @objtype (object) is wrong.
  • SSIS package fails with out of memory errors
  • Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID ‘ ‘) online (Error code 5018).
  • SQL Server cluster installation checklist
  • PREEMPTIVE_OS_AUTHORIZATIONOPS waits in SQL Server
  • SQL Server Backup compression
  • Types of isolation levels in SQL Server

14 Responses to ““Value cannot be null” when i connect SQL Server from SSMS”

1. 

   Regina said

   November 16, 2011 at 10:00 PM

   It does help! 🙂
   Thank you!
   –R

   Reply
2. 

   Suhas said

   January 24, 2012 at 11:00 AM

   Can you let us know the cause of the issue? I mean, why does “Run as Administrator” fix the problem.

   Sorry, but I feel it a big challenge to remember to launch SSMS everytime as “Run as Administrator”.

   Suhas

   Reply
   • 

     Karthick P.K said

     January 24, 2012 at 6:13 PM

     Hello Suhas,

     Disable UAC at your own risk :).
     When UAC is enabled and if you open SSMS as standard user you may not get full permissions on C:\Users\Username\AppData\Local\Microsoft\ (or) %Temp% dir.
     This will cause “Value cannot be null.” Error.
     Even if %Temp% is not set properly in environment variables we might end up with error.
     More info about UAC on http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx

     Thanks
     Karthick P.K

     Reply
3. 

   Srikanth Jasti said

   July 3, 2012 at 2:23 AM

   Hi I am also getting same error but if I try to run as administrator still I am getting the same error…. what could be the problem anyone help me?

   Reply
   • 

     Karthick P.K said

     August 12, 2012 at 3:59 AM

     Check if environment variable for TEMP has valid path

     Reply
   • 

     Sane said

     August 17, 2012 at 7:18 AM

     Karthick P.K said
     August 12, 2012 at 3:59 AM
     Check if environment variable for TEMP has valid path
     ——————————————————————————————-

     Also check that there is space for the Temp

     Reply
4. 

   Carl said

   September 24, 2012 at 3:06 PM

   It also appears to be a sympton of running out of space on the C drive.

   Reply
   • 

     Naresh said

     July 31, 2013 at 2:12 PM

     Thanks Carl !
     When C Drive doesnt have Space this error is encountered

     Reply
5. 

   Manoj Gupta said

   August 29, 2013 at 3:31 PM

   1.Go to windows Run and search there name like %temp% .

   2.Below path will be opened on new windows.

   C:\Users\Administrator\AppData\Local\Temp

   3. Above path you have to create one folder & its name is 2. Like as below.
   C:\Users\Administrator\AppData\Local\Temp\2

   4. Now close the session of SQL server and start the Management studio.Your SQL will be work properly.

   I have resolved the said issues with my given 4 steps.

   Reply
   • 

     Ann said

     March 11, 2021 at 8:44 PM

     thank you. it worked for me

     Reply
6. 

   Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said

   January 11, 2014 at 12:59 PM

   […] “Value cannot be null” when i connect SQL Server from SSMS […]

   Reply
7. 

   Minecraftserverhostinginc.Blogspot.com said

   August 2, 2014 at 5:35 PM

   I don’t even know how I ended up here, but
   I thought this post was good. I do not know who you are but definitely you’re going to a famous blogger if you aren’t already 😉 Cheers!

   Reply
8. 

   Geoffrey said

   August 9, 2014 at 12:10 AM

   Hello, after reading this awesome post i am too glad to share my knowledge here with friends.

   Reply
9. 

   Sharyn said

   September 18, 2014 at 2:25 AM

   I like the helpful information you provide in your
   articles. I’ll bookmark your weblog and check again here regularly.
   I am quite sure I will learn many new stuff right here!
   Good luck for the next!

   Reply